Posts
1150
Comments
891
Trackbacks
1
SQL: Ghost Cleanup

From: http://www.sql-server-performance.com/glossary.asp

“When rows are deleted from the leaf level of an index, the are not removed immediately. Instead, they are marked as invalid and are called ghost records. Periodically, SQL Server starts a special housekeeping thread that locates and removes the ghost records.”

posted on Monday, October 03, 2005 10:41 AM Print
Comments
Gravatar
# re: SQL: Ghost Cleanup
Jomon
4/22/2009 12:32 AM
Awesome.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 5 and 2 and type the answer here: