Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

An Introduction to Schemas in SQL Server 2005 and SQL Server 2008 (Video Series)

Video Image Video Category: The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
Schemas are not complicated but, for whatever reason, people often get confused when working with them. This series tries to help you understand what schemas are and when/where to use them. This is a great series for both newbies, people coming from Oracle or other systems, and is definitely great for someone moving from SQL Server 2000.

Videos in this Series:


Miscellaneous Bits & Pieces:
Keyboard Shortcut for SQL Server Management Studio: CTRL+F4 will close the current query pane yet not close the Management Studio
Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system
Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse

Other Websites We Offer
LearnSqlServer.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!
 
1/8/2009 2:58:31 PM