Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

Understanding SQL Server Page Structure: How Page Splits Affect Performance (Video Series)

Video Image Video Category: Architecture: System Databases, System Tables, and SQL Server Internals

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005
This essential video series will be teaching you about the different types of functions and how, why and what happens when a page splits and how it affects you!

Highlights:
  • Building a Clustered Index in TSQL Overview
  • Discussion about Page Types
  • Introduction to the use of the OBJECT_NAME() function
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Introduction to SQL 2005's Dynamic Management Objects (DMs)
  • About fragementation when page splits occur
  • Detailed explanation of the undocumented FN_DBLOG() function
  • Introduction and explanation of Housekeeping Threads and Ghost Records

Videos in this Series:


Miscellaneous Bits & Pieces:
Book You Should Probably Own: Kalen Delaney's "Inside SQL Server 2005"
SQL Server 2000 Service Pack 4 Features: Changes were made to the visual tools: the table designer, the diagrams, and the Query Designer which make them more secure and reliable
Helpful Keyboard Shortcuts: "CTRL" + "Page Up" navigates forward between panes/worksheets/tabs in an application (use "Page Down" to navigate backwards)

Other Websites We Offer
LearnCSharp.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/6/2009 7:44:00 PM