Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server.
Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
Tuesday, October 16, 2018
How to tell if statistics are actually being updated
Even if everything 'looks' good:
SELECT 'Index Name' = i.name,
'Statistics Date' = STATS_DATE(i.object_id, i.index_id)
FROM sys.objects o
JOIN sys.indexes i ON o.name = 'ORDERs' AND o.object_id = i.object_id;
GO
No comments:
Post a Comment