Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Ghost Cleanup RE: Ghost Cleanup

  • January 15, 2013 at 8:35 am

    #1577369

    IgorMi (1/15/2013)

    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

    Absolutely correct (and this was pointed out in the demonstration example on my blog at http://blog.waynesheffield.com/wayne/archive/2012/12/ghost-cleanup-process/[/url])

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2