RE: Fastes way to increment an id column

SSC Guru

Points: 150467

September 7, 2009 at 2:56 am

Florian Reischl (9/7/2009)
There are a couple of better ways to handle this in SQL Server 2005/2008.

Sure. But for a table which just needs sequential row numbers adding to it, even 2008 doesn't have a faster method.

I thought it was an interesting use of IDENTITY, and SWITCH.

I enjoyed the article too.

Haven't seen you around much recently...?

Paul