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

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ

Learn LINQ in relation to TSQL, Orcas and many more

Published 25 July 7 5:4 AM | SSQA.net

In continuation to my post on Linq-TSQL I was drowing on web to know more about LINQ and how-to in relation to TSQL. Here comes the resources I have used and using so far in getting information about LINQ: First, MSDNForum link on "What is LINQ?...

Filed under: microsoft, blogs, linq, location, tsql, learning, backups