Query to get a list Statistics in the database (from sys.sysindexes table)
Query to get a list Statistics in the database (from sys.sysindexes table)
select name, rowcnt, rowmodctr,* from sys.sysindexes where rowcnt = 0 and name like ‘%_WA%’
All Statistics objects in the sys.sysindexes have rowcnt = 0 and its name starts from ‘_WA’