INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
These is the process which can’t be stopped. If you restart your server without knowing what this is, your efforts would be totally waste. Once the sql server comes up, you will again see them. So the question is what exactly GHOST CLEANUP is.
When any record is deleted then on the page header the bit is changed only and record remains there. This record is marked as GHOST record. This way your delete process is fast. GHOST CLEANUP is an internal DB engine mechanism which starts later on and delete these records.
If you see that GHOST CLEANUP is running it means that records are getting deleted physically which have been marked GHOST some time back.
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com