Browse by Tags

TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

Published 14 July 8 5:26 AM | SSQA.net

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...

Filed under: sql server, dmv, tsql, sysindexes, query plan, querystats

SQL Server 2000 - list the current Statistics names that exist on a table

Published 5 November 7 9:0 AM | SSQA.net

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...

Filed under: sql server, tsql, statistics, sysindexes, tablename, wa_sys