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 Server 2000 Videos in Series Home  Subscriber Videos  

Using Profiler in SQL Server 2000 (Video Series)

Video Image Video Category: Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2000
This series is more than an introduction: you'll get in-depth knowledge of many of the most common screens within Profiler as well as Best Practices for using Profiler and creating SQL traces. This should be considered mandatory viewing by anyone wanting to become a DBA or who wants to be a serious developer.

Videos in this Series:


Miscellaneous Bits & Pieces:
Performance Tip: TRUNCATE TABLE is much faster than DELETE when removing all rows from a table. One caveat: TRUNCATE TABLE cannot be run on a table with foreign keys
SQL Server 2000 Resource Kit - More Helpful Tools: USP_ShutdownDB is a script that kills all users in a database. Very useful
Windows Server 2003 Tips and Tricks: You can now disable the original "Administrator" account. One bonus tip: create a separate account with administrator privileges before disabling the "Administrator" account

Other Websites We Offer
LearnReportingServices.com
Don't Forget!
Become a Guru
 
   
 
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!
 
8/20/2008 3:27:38 AM