2012.12.20

Update

   

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 10

• KB Article:  KB #2783135
• 16 fixes are listed at the time of publication
• Build number is 10.50.2868
• Relevant for @@VERSION 10.50.2500 through 10.50.2867

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 4

• KB Article: KB #2777358
• 34 fixes are listed at time of publication
• Build number is 10.50.4270
• Relevant for @@VERSION 10.50.4000 through 10.50.4269

Cumulative Update #5 is available for SQL Server 2012 RTM

• KB Article: KB #2777772
• Build # 11.0.2395
• 28 fixes at the time of writing

   

MSSQL

• Performance and Stability-Related Fixes in Recent SQL Server 2008 SP3 Cumulative Updates

  http://www.sqlskills.com/blogs/glenn/post/performance-and-stability-related-fixes-in-recent-sql-server-2008-sp3-cumulative-updates.aspx

   

• Disk and File Layout for SQL Server

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/19/disk-and-file-layout-for-sql-server.aspx

     

• Hypothetical Indexes on SQL Server

  http://www.simple-talk.com/sql/database-administration/hypothetical-indexes-on-sql-server/

  가상 인덱스? 유용한 인덱스 여부를 판단하기 위해 테스트 하기 위해 사용하기 위해서는 WITH STATISTICS_ONLY=1로 주시면 됩니다. DTA(Database tunning Advisor)에서도 사용합니다. 가상 인덱스를 사용하기 위해서는 SET AUTOPILOT ON 또는 DBCC AUTOPILOT를 활성화 해줘야 합니다.

  

     

• SQL Server Encryption To Block DBAs Data Access

  http://www.mssqltips.com/sqlservertip/2840/sql-server-encryption-to-block-dbas-data-access/

     

• Database size information - SQL Server
  http://beyondrelational.com/modules/2/blogs/88/Posts/18575/database-size-information-sql-server.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29

     

• Checking SQL Server Services Owner

  http://www.mssqltips.com/sqlservertip/2823/checking-sql-server-services-owner/

     

• SQL Server 2012 Best Practices Analyzer TempDB Recommendations

  http://www.mssqltips.com/sqlservertip/2833/sql-server-2012-best-practices-analyzer-tempdb-recommendations/
   

• SQL SERVER – Select the Most Optimal Backup Methods for Server
  http://blog.sqlauthority.com/2012/12/18/sql-server-select-the-most-optimal-backup-methods-for-server/