Monday, February 28, 2011

Ghost clean up

Excellent post by Paul S Randall.
When a record is deleted from the table, SQL Server marks it as Ghost record which will be cleaned up when the background ghost clean job runs every 5 sec.

Thanks to Paul, he has just accepted my request to refer his post, Here is the link for his post.

No comments:

Post a Comment