The 14 million logical reads for Itzik's code is pretty much what I'd expect out of the triangular join he built into his code. Why that dropped to only...

Wow... I'm thinking the dev box has a major problem.

Although there is much good to be said about having a clustered index, if the only PK that's available is a GUID, my recommendation would be to just forget about...

It sounds to me as if someone built in a memory leak in the CLR.

Search the sysComments table(s) for any occurance of sp_OA. But, now that you've told us more, I don't believe that's the problem... 2GB of RAM is woefully inadequate for...

LMAO!!! Oh My! That second...

Matt Miller (1/9/2009)

---

GilaMonster (1/9/2009)

---

DavidB (1/9/2009)

---

Maybe if you just post the link to the article about how to effectively post the OP will eventually get it. Maybe a bit like Tennis...

Grant Fritchey (1/9/2009)

---

There's a whole section on identifying gaps in Itzik Ben-Gan's book T-SQL Querying. Here's a way to list all the gaps, their start points and stop points:

SELECT cur+1...

foxjazz (1/9/2009)

---

I realize you guys aren't mind readers, maybe I should restate the requirements to say lowest possible positive unused value.

I found that I already had an identity set,...

Ok... that was fun... here's a function to do what you want. The function will make it easy and consistent on folks to use and I tried to build...

Thanks for taking the time to explain. Even though it's for a necessarily RBAR action for a GUI and there's probably no need to handle the proverbial "millions of...

That's a very good question and you're absolutely correct... sp_OA had some pretty nasty memory leaks. I don't actually use sp_OA for that and other reasons, so I've...

Heh... But, it won't solve a bloody thing and it won't prevent the problems that you describe... people will simply get into the habit of adding WHERE 1=1 and still...

Ah... that's a slightly different story. Am I to assume that you want the digit to be inserted in the correct ascending numerical order... in other words, the 7...

"Go Team" is right!

If I may, please consider what...