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  
XML and SQL Server - FOR XML, SQLXML, MSXML, and More - Video Category (all video categories)
Video Image XML support in SQL Server began in SQL Server 7.0 and has continued to grow in both expansiveness and popularity. This category focuses on using XML in SQL Server - when is it appropriate, how to use it, et al - and offers several practical examples of using XML.

Versions/Editions Covered: SQL Server 2005
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) - Introduction to the FOR XML Clause   300 (Click for Videos) 29 mins.
Series (5 videos) - Introduction to Using XML in SQL Server   300 (Click for Videos) 76 mins.
XML Schema Collections and Using Typed and Untyped XML Data   400 Download 12 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Tips and Tricks: Create your own customized MMCs (Microsoft Management Console) for easier administration. Go to the command-line and run the command "MMC" to launch the MMC window. All that's left is for you to add in the various snap-ins you want to work with and then save the file
Performance Tip: "WHERE LastName LIKE 'Sm%'" is a fast query but "WHERE column LIKE '%Sm%' is a performance killer. Imagine searching in a phone book for anyone whose last name starts with 'Sm' - easy right? Now try to find anyone whose last name contains the two letters 'sm'. There's a huge difference in the number of pages required to satisfy the two queries
Did you know that the fixed server role "Database Creators (dbcreator)" can drop any database on the server? Ouch!
Video search
Company News
SSIS Training
     
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:49:54 PM