Description:
This is the first 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:
- Basic Launching of SQL Server Management Studio
- Identifying Service Pack 2
- Proper TSQL Database Creation
- Index Page Limitations
- Proper TSQL Table Creation
- Building a Clustered Index in TSQL Overview
- Database Console Command (DBCC) function definition and functionality
- Introduction and explanation of the DBCC IND() function
- Proper syntax while utilizing the DBCC IND() function
- Explanation of the functionality of the DBCC IND() function
- Properly utilizing the INSERT statement in TSQL
- Discussion about Page Types
- SQL Script accompanies the video
Trainer, Scott Whigham, gives us an excellent start to a fantastic video section that will put you in the right direction for learning about page splits. This video will provide more information that you knew existed about the different types of functions and how, why and what happens when a page splits. This video is extremely informative and is definitely for everyone that wishes to learn at any level; beginner, intermediate and advanced users of SQL Server alike. Beginner users will want to watch the video and come back and watch it again to get the most of out it.
NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Download
and watch this video