This video is 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)

Video: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Skill level: 500 (Advanced)
Run Time: 16:45
Instructor: Scott Whigham

Description:

This excellent step-by-step walk-thru of Scott Whigham's Stored Procedure video is the second video in a section of 3. This is an excellent addition to this section that teaches us about an extremely complex stored procedure in non-technical explained terminology. A few of the highlights but definitely not limited to are as follows:

Introduction to properly declared variables
TSQL IF and ELSE statements
TIMEOUT Statement
WAITFOR Statement
Basic introduction to xpath and xquery

This whole video is dedicated to the masterfully written stored procedure. This is an advanced video therefore is perfect for the intermediate to advanced SQL SERVER users. You will need to know about TSQL in order to follow a lot of this video.

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Video titleSkill

Part 1 - An Overview of the Default SQL Server Installation	100	Download
Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005	200	Download
Creating Database Diagrams in SQL Server Management Studio	200	Download
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands	300	Download
Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites	100	Download

CourseRun TimeSkill Level

153 - SQL Server 2005 Integration Services	200-500	31+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
150 - SQL Server Programming (SQL Server 2005/2000): Transact SQL	200-500	37+ hrs
157 - SQL Server 2008 Database Administration	200-500	45+ hrs
189 - C# Programming with Visual Studio 2005	100-300	30+ hrs

Chapter 13: Miscellaneous - Topics That Do Not Fit Anywhere Else!

1	Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins
	Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works
3	Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log
4	Part 1 - How to Make a Table Read-Only in SQL Server
5	Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup
6	Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!)
7	Pt. 1 - An Introduction to Bulk Operations in SQL Server
8	Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads
9	Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS
10	Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios
11	Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File
12	Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files
13	Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations
14	Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes
15	Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP
16	Pt. 10 - SQL Server Intergration Services BULK INSERT Task
17	Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task
18	Pt. 12 - Understanding the FastParse Option

NOTE: This video is part of our SQL Server 2005 Database Administration course.
This video is from Chapter 13: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Login

Video: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Description:

Scott Whigham