Browse by Tags

All Tags » sql server » columns » statistics   (RSS)
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...