2013.05.27

   

SQL

   

• DBCC SqlPerf

  http://stevestedman.com/2013/05/dbcc-sqlperf/

   

• DBCC ShrinkFile

  http://stevestedman.com/2013/05/dbcc-shrinkfile/

     

• DBCC ShrinkDatabase

  http://stevestedman.com/2013/05/dbcc-shrinkdatabase/

     

• T-SQL Script to find out the database file size, space used and available free space

  http://sqldbpool.com/2013/05/26/t-sql-script-to-find-out-the-database-file-size-space-used-and-available-free-space/

     

• The Optomizer Isn't As Smart As You Might Want It To Me

  http://itknowledgeexchange.techtarget.com/sql-server/the-optomizer-isnt-as-smart-as-you-might-want-it-to-me/

     

• Error Handeling and DBCC CHECKDB

  http://itknowledgeexchange.techtarget.com/sql-server/error-handeling-and-dbcc-checkdb/

     

• Recommended reading from mrdenny for May 24, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-may-24-2013/

     

• Shredding XML with Powershell and SQL Server

  http://www.sqlserver-dba.com/2013/05/shredding-xml-with-powershell-and-sql-server.html

     

• Using source data from an SSRS report in PowerPivot for Excel

  http://www.mssqltips.com/sqlservertip/2940/using-source-data-from-an-ssrs-report-in-powerpivot-for-excel/

     

Other

   

• 마세라티 문제에 대한 말도 안되는 개인적인 생각

  http://charsyam.wordpress.com/2013/05/26/%EB%A7%88%EC%84%B8%EB%9D%BC%ED%8B%B0-%EB%AC%B8%EC%A0%9C%EC%97%90-%EB%8C%80%ED%95%9C-%EB%A7%90%EB%8F%84-%EC%95%88%EB%90%98%EB%8A%94-%EA%B0%9C%EC%9D%B8%EC%A0%81%EC%9D%B8-%EC%83%9D%EA%B0%81/