reidres (2/24/2010)

---

OK, Tom. The thing with your TSQL seems to be that while you are indeed generating the numbers, you are not specifically doing so in a way that...

Lynn Pettis (2/24/2010)

---

Don't know, Tom, on the server I am using here at work yours actually runs about 4 time longer than my code, about 4 seconds.

Really comes down to...

I'm slightly concerned about the apples and oranges issue: is what you are measuring just generating a cte with the numbers...

tstaker (2/24/2010)

---

I've only used Tally tables when running through the articles on this site and haven't had an opportunity to use them in production. In an interview I would of...

I know how you feel - I...

RBarryYoung (2/23/2010)

---

And here in a nutshell is demonstrated exactly what has been wrong with the academic discipline of Relational Theory for the last 30 years: A complete inability to...

RBarryYoung (2/23/2010)

---

Well, I did read...

tony rogerson (2/18/2010)

---

Sets have no order, they are operated on in their entirity in one go - not a row by row!

Quirky update is no more set orientated than a...

tony rogerson (2/18/2010)

---

IF you are saying you are happy for this to be used in a production environment then frankly should be sacked because it is clear and proven that...

Jeff Moden (10/2/2009)

---

--===== Find the "gap ranges"

-- This assumes that gaps include any whole number greater than 0

SELECT GapStart = (SELECT ISNULL(MAX(b.MyID),0)+1

...

Great article, Lynn. Extremely interesting, and good clear testing report and data.

All those people querying why generate it dynamically amaze me - I wouldn't dream of having a static...

the sqlist (9/22/2009)

---

Here is another version that WILL work on any SQL version and the code is pretty much self descriptive and easy to understand by everyone. I agree that...

Jeff Moden (2/23/2010)

---

Gary Varga (2/23/2010)

---

OK. Perhaps two articles. The one you suggest...

Jeff Moden (2/23/2010)

---

Tom.Thomson (2/22/2010)

---

By the way, there was method in choosing a hundred million as a limit - it's big enough to need a 3-way cross join of master.sys.all_columns to...

It's a pity it's asking for the wrong enhancement, instead of for implementaton of range expressions generally.