Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Ghost Cleanup RE: Ghost Cleanup
Igor Micev
SSC-Dedicated
Points: 33109
More actions
January 15, 2013 at 8:18 am
#1577360
Hi,
Interesting question!
The expected one data page will be listed after rebuilding the index on the table.
alter index PK_Test on dbo.Test rebuild
dbcc ind ('TestDB','Test',1)
Thanks,
IgorMi
Igor Micev,My blog: www.igormicev.com