2013.03.11

   

SQL

   

• Top 10 Free SQL Server Tools

  http://www.johnsansom.com/top-10-free-sql-server-tools/

  참고로 전 9번 ClearTrace툴을 요긴하게 많이 썼습니다^^

     

• Recommended reading from mrdenny for March 08, 2013

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

     

• How to check for SQL ghost records?

  http://www.sqlserver-dba.com/2013/03/how-to-check-for-sql-ghost-records.html

     

• BCP - Changing the default column terminator

  http://beyondrelational.com/modules/2/blogs/70/posts/19120/bcp-changing-the-default-column-terminator.aspx

     

• SQL Server Maintenance Plans and Parallelism – Index Rebuilds

  http://www.sqlskills.com/blogs/erin/sql-server-maintenance-plans-and-parallelism-index-rebuild/

     

• SQL WAIT TYPE – DTC and how to reduce it

  http://www.sqlserver-dba.com/2013/03/sql-wait-type-dtc-and-how-to-reduce-it.html

     

• Six Scary SQL Surprises

  http://www.red-gate.com/products/dba/dba-bundle/entrypage/hard-earned-lessons-3

     

     

     

ETC

   

• 5 Tips for Effective Technical Documentation        

  http://sqlsalt.com/5-tips-for-effective-technical-documentation/