May 19, 2021 at 4:28 pm
If I did update stats on tables on a database in which table the information is stored about the stats updated on the database
May 19, 2021 at 7:39 pm
You can query details using sys.dm_db_stats_properties https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-stats-properties-transact-sql?view=sql-server-ver15
SELECT sp.stats_id, name, filter_definition, last_updated, rows, rows_sampled, steps, unfiltered_rows, modification_counter
FROM sys.stats AS stat
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE stat.object_id = object_id('TEST');
May 20, 2021 at 8:48 am
Also....
sp_autostats table_name
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply