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  
Design Patterns for Transact-SQL - Video Category (all video categories)
Video Image Simplify your life by working from patterns in SQL. Although most people think of object-oriented languages when they hear of design patterns, SQL has its own design patterns although many are not classicly categorized as such.

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 (2 videos) - JOINs in SQL - Using a Design Pattern to Write Two and Three...   200 (Click for Videos) 21 mins.
Series (3 videos) - How to Delete Duplicate Rows In Your SQL Server Tables Using...   500 (Click for Videos) 28 mins.
Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows...   300 Download 13 mins.
Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows...   300 Download 14 mins.
Design Pattern for Looping Through Rows and Executing A Stored Procedure - Using...   400 Download 15 mins.
Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your ...   200 Download 7 mins.
Two Ways to Generate Random Numbers and Random Rows From a SQL Server Table (SQL...   300 Download 17 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML"
Performance Monitor (also called System Monitor and perfmon) is a great tool used to track various processes on the system and to give an ad-hoc display of the current state of the system. Perfmon is a very flexible tool allowing you to monitor memory, CPU, hard drive statistics as well as individual application statistics like how much memory your SQL Server is using.
If you see a file/folder that is green in color in Windows Explorer that is an indication that the file is encrypted using EFS (Encrypted File System)
Video search
Company News
T-SQL Training Videos
     
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.
7/26/2008 7:58:34 PM