Browse by Tags

SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?

Published 4 September 8 3:0 AM | SSQA.net

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...

Filed under: sql server, blogs, best practices, pages, backups, checksum, dbcc checkdb, Corruption, page_verify

Cumulative Update 8 package for SQL Server 2005 Service Pack2

Published 16 July 8 4:50 AM | SSQA.net

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...

Filed under: sql server, blogs, best practices, service pack2, 2005, cumulative update, cu7

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin