JOIN sys.columns c ON sc.object_id = c.object_id JOIN sys.stats s ON s.object_id = o.object_id Stats_date(o.object_id, s.stats_id) AS stats_date SELECT o.name, s.stats_id, s.name, s.auto_created, s.user_created, If there are queries running against that table, yes I would check update stats and if it is outdated I would run US >Do we need to run update statistics on the table which get insert 10k records everyday.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |