Blog Post

Query Your Statistics: dm_db_stats_properties

,

We’ve always been able to look at statistics with DBCC SHOW_STATISTICS. You can even tell SHOW_STATISTICS to only give you the properties, STAT_HEADER, or histogram, HISTOGRAM. However, it’s always come back in a format that you can’t easily consume in T-SQL. From SQL Server 2012 to everything else, you can simply query sys.dm_db_stats_properties to get […]

The post Query Your Statistics: dm_db_stats_properties appeared first on Grant Fritchey.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate