This chapter comes from our "SQL Server 2005 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 7: Architecture: System Databases, System Tables, and SQL Server Internals

The more you know about how things work in SQL Server, the better prepared you are to make intelligent design and management choices. Watch this chapter for information on how the internals of Microsoft SQL Server 2000 influence your design making. You'll learn the details about the master database, the msdb database, how the resource database is used by SQL Server, and how to take advantage of the model database for fun and profit. This video includes detailed walk throughs of the objects in each database complete with descriptions and suggestions for use for many of the most commonly used objects (system tables, system views, system procs and more).

Videos in Chapter 7

1How SQL Server 2005 Uses the Registry and Changes to the Registry Download
2How SQL Server Logs Errors - The SQL Server Error Log and Configuration Download
3Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005) Download
4TempDb Database - An Overview of How it Works and When to Use It Download
5How to Change the Master Database's File Locations Download
6Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure Download
7Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) Download
8Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs Download
9Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log Download
10Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? Download
11Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download
12Part 2-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download
13Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download
Download this chapter

Browse this course's videos now

© Copyright 2004-2009 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.