Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mohammed Arshad Get Index Scan Count RE: Get Index Scan Count
Sue_H
SSC Guru
Points: 90860
More actions
January 8, 2018 at 3:02 pm
#1974982
One problem with the script is that it is hard coded to use db_id 70 when using this: sys.dm_db_index_physical_stats (70, NULL, NULL, NULL, NULL) AS p
Maybe change that to Default, null or 0 instead of 70
Sue