Browse by Tags

All Tags » statistics   (RSS)
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...
TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
04 September 07 07:32 AM | SQL Master | 2 Comments   
PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query Read More...
How do I find all the statistics and statistics columns on a specified object?
09 August 07 02:59 AM | SQL Master | 1 Comments   
Run this TSQL on the database where you want to obtain the statistics information: SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id Read More...