Browse by Tags

All Tags » sysindexes   (RSS)
TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005
14 July 08 03:26 AM | SQL Master | 2 Comments   
DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10 total_logical_reads, Read More...
SQL Server 2000 - list the current Statistics names that exist on a table
05 November 07 08:00 AM | SQL Master | 2 Comments   
Using Query Analyzer you can list an execution plan for a query , where you can find/get any statistics that are missing for that query. So to see the create missing statistics you will get further information such as Statistics name and so on and further Read More...