Archives for: "August 2009"

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity… more »

Cumulative update package 5 for SQL Server 2005 Service Pack 3

The cumulative update package 5 for SQL Server 2005 Service Pack 3 (Build 09.00.4230) is available: http://support.microsoft.com/kb/972511.The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released:… more »

Fast and Reliable Backup and Restore of a VLDB over the Network

Thomas H. Grohser discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs) in this SQL Server Technical… more »

Technical Note - DBCC Checks and Terabyte-Scale Databases

Stuart Ozer has published a technical note at SQLCAT. http://sqlcat.com/technicalnotes/archive/2009/08/13/dbcc-checks-and-terabyte-scale-databases.aspx CU tosc more »

High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study

SQLCAT, has published a new whitepaper / technical case study High Availability and Disaster Recovery at ServiceU for SQL Server 2008. Follow up: SQLCAT:… more »

Plan Caching in SQL Server 2008

Greg Low, has published a whitepaper Plan Caching in SQL Server 2008, it's an update of the whitepaper "Batch compilation, Recompilation and Plan Caching Issues in SQL Server 2005" by Arun Marathe, targeted at SQL Server 2008. Summary: This paper… more »