Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
     
Transact SQL Training Videos             * SQL Server DBA Tutorials
* Integration Services Training
* More Videobooks...
Email
Password
Register
LearnTransactSQL.com Subscriber Videos
Transact SQL Videos By Category Home  Subscriber Videos  
Index Design, Plan Guides, Execution Plans and Query Plans for SQL Server: Performance Tuning Your Queries - Video Category (all video categories)
Video Image If performance matters to you, then you need to know what's happening "under the hood" of SQL Server. You need to need whether or not your statistics are up to date, whether your queries are using your indexes and what tweaks, if any, you can use to work with large tables. Check out these tutorials for your speed fix.

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
TitleSkillView / DownloadLength
Series (6 videos) - Understanding Plan Caching in SQL Server   New! 300 (Click for Videos) 72 mins.
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Com...   300 Download 21 mins.
Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)   200 Download 16 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "CTRL" + "ESC" displays the Start Menu
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons
You can store your own custom error messages in your SQL Server's master database
Video search
Company News
Download free videos from LearnItFirst.com
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
8/7/2008 6:40:10 PM