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

A Lecture on Using IDENTITY Columns in Table Design and Surrogate Keys (Video Series)

Video Image Video Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
So much is written and talked about IDENTITY columns that, for someone new to SQL Server and/or relational database design, it can get confusing to know whether or not to use a surrogate key, such as an IDENTITY column or a GUID. This series takes a hard look at IDENTITY columns and lets you decide after you see the good and bad of IDENTITY columns.

Videos in this Series:


Miscellaneous Bits & Pieces:
Performance Tip: The Transact-SQL command BULK INSERT is likely to be faster than the bulk copy program (bcp) because BULK INSERT runs in-process with SQL Server.
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to Transact-SQL"
Helpful Keyboard Shortcuts: "Windows key" + "E" quickly brings up Windows Explorer

Other Websites We Offer
LearnSharePoint.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!
 
9/8/2008 8:45:22 AM