2013.02.01

SQL

   

• A creative use of IGNORE_DUP_KEY

  http://sqlblog.com/blogs/paul_white/archive/2013/02/01/a-creative-use-of-ignore-dup-key.aspx

   

• Why does SQL Server not compress data on LOB pages?

  http://sqlblog.com/blogs/hugo_kornelis/archive/2013/01/31/why-does-sql-server-not-compress-data-on-lob-pages.aspx

     

• Why PowerShell for SQL Server?

  http://www.sqlmag.com/article/powerscript/powershell-sql-server-145103

     

• Best Practices + Table Partitioning: Merging Boundary Points

  http://www.brentozar.com/archive/2013/01/best-practices-table-partitioning-merging-boundary-points

     

• Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index

  http://www.sqlsoldier.com/wp/sqlserver/day24of31daysofdisasterrecoveryhandlingcorruptioninaclusteredindex

  와우^^. 장애 복구~ 백서수준이네요~

     

• Evaluating Policies on Multiple SQL Server Instances using Central Management Server

  http://www.mssqltips.com/sqlservertip/2859/evaluating-policies-on-multiple-sql-server-instances-using-central-management-server/

     

• SQL SERVER – Significance of Table Input Parameter to Stored Procedure – Guest Post by Vikas Munjal – Koenig Solutions

  http://blog.sqlauthority.com/2013/01/31/sql-server-significance-of-table-input-parameter-to-stored-procedure-guest-post-by-vikas-munjal-koenig-solutions/

     

     

기타        

• [kth 모바일 리포터]스마트폰 이용고객 이제 지갑 열 준비 되었다!!

  http://dev.kthcorp.com/2013/01/31/customer_story5/