Category Archives: SQL Server 2005

SQL Server 2005 SP3 through Microsoft Update now supports clustering

SQL Server 2005 SP3 through Microsoft Update now supports clustering On March 24th, we revised the SQL Server 2005 Service Pack 3 Microsoft Update logic to offer when a clustered instance is detected. When the logic was originally released, the … Continue reading

Posted in SQL Server 2005 | 64 Comments

Which query is scanning that index? Indexes used by Queries?

I came across a blog written by Greg_Linwood, which has the script written by Uma Chandran who was MVP now works for Microsoft… It is really brilliant approach…but as you know UC is one of the many good developers works for … Continue reading

Posted in SQL Server 2005 | 49 Comments

SQL Server 2005 Clustering Tips/Refernces

This is the blog entry from Cindy Gross, and it is very useful and excellent information about clusters… http://mohammedu.spaces.live.com/?_c01_BlogPart=blogentry&_c=BlogPart   SQL Server 2005 Clustering Tips/Refernces   — Handy cluster related info select SERVERPROPERTY(‘IsClustered’) as _1_Means_Clustered , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) as CurrentNode , … Continue reading

Posted in SQL Server 2005 | 100 Comments

SQL Server 2005 Cumulative Update (CU) 7

SQL Server 2005 Cumulative Update (CU) 7 is now available – Check the following link…  http://support.microsoft.com/kb/949095/en-us

Posted in SQL Server 2005 | 85 Comments

DMVStats – Performance Datawarehouse Application

DMVstats 1.0 – A SQL Server 2005 Performance Data Warehouse Application Author:         Tom Davidson Reviewer:      Sanjay Mishra   Introduction Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance … Continue reading

Posted in SQL Server 2005 | 27 Comments