Monthly Archives: June 2008

Indexusage stats

The following script is written by Greg_Linwood, it very useful when you want to check your index usage based on the table…  create procedure [dbo].[usp_helpindexusagestats] @tablename varchar(1000) as set nocount on   –collect output from system supplied [sp_helpindex] if object_id(‘tempdb..#helpindex’) > … Continue reading

Posted in SQL Server 2005 Scripts | 56 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

Database size free and used

set nocount on declare @cmd varchar(500) declare @db varchar(128) create table #results(FileType    varchar(4) NOT NULL,                       [Name]      sysname NOT NULL,                       Total       numeric(9,2) NOT NULL,                       Used        numeric(9,2) NOT NULL,                       [Free]      numeric(9,2) NOT NULL,                       dbname      sysname NULL) create … Continue reading

Posted in SQL Server 2005 Scripts | 66 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…   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 2008 RC0 is out.  

Posted in SQL Server 2008 | 39 Comments