About the Talk
May 12, 2012 12:30 PM
Jefferson State Community College Shelby-Hoover CampusJefferson State Community College Shelby-Hoover Campus
SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more.