Description:
This is the fifth video of a section of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
- Reviewing Ghost Records
- Introduction and definition of m_ghostRecCnt
- Introduction and explanation of Housekeeping Threads
- Real life examples of housekeeping threads
- Limitations when deleting records before housekeeping threads remove GhostRecords
- Definition and explanation of correct terminology when utilizing fn_dblog() function
Renowned trainer, Scott Whigham, has completed this video section maximizing your knowledge on page splits by utilizing his years of experience and training to teach us about ghost records. 100 percent of this video is dedicated to ghost records. If you have never heard of ghost records or are just looking to freshen your memory, this is the video for you. All skill levels can understand and follow this video and will be better off for having watched it. This is an excellent conclusion to a section of already absolutely fantastic videos.
NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Download
and watch this video