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  
Server-Side Storage: Temp Tables, Table Variables, Cursors and More - Video Category (all video categories)
Video Image Every application of any decent size today makes use of server-side storage although how they do it will vary widely with each. Temporary tables are "old school" but, due to scoping, often the easiest way to solve your temporary storage needs. Table variables are the "new thing" but they can't do it all. What about cursors? They are the "lost child" of the modern SQL world but, yes, they are still viable programming constructs. The videos in this category are meant to help you understand the when and where to use these objects but also try to help you think of alternatives.

Versions/Editions Covered: SQL Server 2000
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
Choosing Between Cursors, Table Variables and Temp Tables (SQL Server 2000)   300 Download 19 mins.
The Differences Between Local Temporary Tables and Global Temp Tables and When t...   300 Download 13 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Keyboard Shortcut for SQL Server Management Studio: Shift+F1 brings up the context-sensitive help in Books Online
The command-line command "ipconfig" is an essential tool for all Windows sysadmins. It allows you to view network adapter information such as IP, DNS, gateways and much more
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Architecture And Internals"
Video search
Company News
SSRS tutorials
     
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:28:02 PM