This session is about tools in T-SQL that allow you to generate a sequence of values, often used as surrogate keys, but sometimes for other purposes. The session covers the identity column property and the limitations it imposes. It covers the sequence object, and compares and contrasts it with the identity property, including a performance comparison. If time permits, the session will also discuss generating sequences of integers with the ROW_NUMBER function, and describe some creative ways to use it.
