DENALI SEQUENCE Archives - SQLServerGeeks

SQL Server 2012: SEQUENCE Feature RTM restrictions and update

April 7, 2012November 29, 2014 - by Amit Bansal - Leave a Comment

Hi Friends, I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here: https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-object/ https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-object-part-2/ https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-feature-part-3-re-seeding-restarting-incrementing-cycling/ Now that the …

SQL Server

SQL Server 2012: DENALI series: SEQUENCE feature Part 3 – Re-seeding, Restarting, incrementing & Cycling

November 25, 2011November 28, 2014 - by Amit Bansal - 2 Comments.

Hi Friends, Here is part 3 of my sequence of blogs on SEQUENCE object 🙂 In part 1, I blogged on how SEQUENCE objects in DENALI behave within transactions. You can …

SQL Server

SQL Server 2012: DENALI series: SEQUENCE OBJECT – Part 2

November 15, 2011November 28, 2014 - by Amit Bansal - 4 Comments.

Hi Friends, My bad; what I should be blogging as Part 1, I am doing as PART 2. Yesterday, I blogged on how SEQUENCE objects in DENALI behave within transactions. You …

SQL Server

SQL Server 2012: DENALI series: SEQUENCE OBJECT

November 14, 2011September 30, 2014 - by Amit Bansal - Leave a Comment

Hi Friends, At Kolkata DevCon 2011, I was demonstrating SEQUENCE OBJECT, and one participant asked if SEQUENCE OBJECTS would respect a transaction. The answer is NO. First, what is a SEQUENCE …