SQL Server Architecture: Indexes, Internals, and Query Plans

Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos

SQL Server 2000 Training Videos							* SQL DTS Training Videos * SQL Programming Videos * More Videobooks...	Search My Account More Videobooks Sign in
Home FREE Video Tutorials Subscriber Video Tutorials Subscriptions FAQs Our Other Sites About Us

Home
- Free Videos
- Subscriber Videos
- Buy Now (Subscriptions)
- More Video Websites
- Search for Videos
- Tag Cloud

Subscriptions
- Subscribe!
- Testimonials
- List of Videobooks

Quick Links
- About the Author
- Login
- FAQs

Site Map

An Overview of the Fixed Server Roles for SQL Server 2000

Creating SQL Server Authentication Logins in the Enterprise Manag...

Creating Windows Authentication Logins in the Enterprise Manager

How to Increase a Database's Size - Multiple Techniques for Incre...

How to Increase a Database's Size Using the SQL Server Enterprise...

SQL Server 2000 Videos By Category	Home Subscriber Videos

SQL Server Architecture: Indexes, Internals, and Query Plans - Video Category (all video categories)

This SQL Server 2000 video tutorial category is all about performance tuning your SQL Server. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the how and why in SQL Server

Versions/Editions Covered: SQL Server 2000 , SQL Server 2005 , SQL Server 2008

Videos in this Category:

orange = video series
blue = individual video

Click "Download" to download the video or click the video title for more information

Title	Skill	View / Download	Length
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys	200	Download	14 mins.
Pages, Extents, and Blocksizes - What They Are and How They Work	300	Download	10 mins.
Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)	200	Download	16 mins.

< Return to list of all videos

Related Links:

SQL Puzzles and Answers - How fun - a whole book of nothing but schema puzzles and query puzzles. Be aware that this book is about SQL, not a particular implementation of SQL

SQL for Smarties: Advanced SQL Programming - Joe Celko is the guru's guru and we all just want to be half as smart as him. Be aware that this book is about SQL, not a particular implementation of SQL

SQL Server Worldwide Users Group - A great newsletter and a nice site

Miscellaneous Bits & Pieces:

SQL Server 2000 Service Pack 4 Features: A new version of OPENXML is included that removes the previous dependency on the version of MSXML used by the OS. SP4 embeds an internal version of MSXML that is backwards compatible with MSXML 2.6

Microsoft SQL Server was originally licensed from Sybase in 1989 and proceeded to be a co-operative design until Microsoft SQL Server 7.0 - the first stand-alone version produced solely by Microsoft

You can use the "PSSDiag.exe (PSSDIAG Data Collection Utility)" to detailed diagnostic information about your SQL Server. Check out Microsoft's Download page and search for "PSSDIAG Data Collection Utility" for more

Company News

» We're also sponsoring the St Louis SQL Server User Group July 9

» We're sponsoring the Billings, Montana .NET User Group July 8

» We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th

» Scott had a baby!

Download free videos from LearnItFirst.com


Home \| About Us \| Advertising \| Become an Author \| Contact Us \| Privacy \| System Req's \| Terms \| Testimonials \| Work for Us! \| \| Site Map
© 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.

7/3/2008 6:32:13 PM