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

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

Video Image Video Category: SQL Server 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:
What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
Security Tip: Do not allow applications to issue SELECT,INSERT,UPDATE, or DELETE statements to your database. Instead create a set of stored procedures and require that your applications use these "interfaces" into your database
The command-line command "net" can be used to for many administrative tasks such as creating shares, creating mapped drives, and much more. Go to command-line, and execute the command "net help" for more details

Other Websites We Offer
LearnSharePoint.com
Don't Forget!
100% Money Back Guarantee
 
   
 
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!
 
11/19/2008 6:01:39 PM