Jeff Moden (9/8/2011)

I meant "much quicker than the Tally Table join. The only other thing to do other than removing the code you pointed out would be to add...

Jeff Moden (9/8/2011)

Thanks for the feedback, Charles...

No... Gap detection isn't one of the jobs that the Tally Table is real performant at because it requires a JOIN to the data...

Jeff,

Your gap detection code is very sweet...

However, I'm wondering what you think of the use of a tally table vs your gap detection if the requirement is to find the...

Interesting discussion, especially since I'm following it from the viewpoint of a developer used to working on a DB that does offer this feature already; namely the IBM i.

When saving...

Simon,

I see that your discussion post mentions multiple servers...

But in the article in question, http://www.sqlservercentral.com/articles/Locking/67952/ only seems to be talking about one server.

So what does the article's technique...

Interesting article....I'm surprised at the hoops you have to jump through.

On DB2 for i, all I need to do is set QQRYDEGREE for the system or for individual jobs to...

IBM's got one....IBM i running on POWER Hardware. ( i is for integrated 😀 )

From 1,2,4 cores with up to 64GB of RAM and 30.6TB of disk

to 64 cores...

Great idea!

An OS built specifically on and around an embedded enterprise class RDBMS.

Of course Microsoft would be a bit late to the party…say 30 years or so; given that the...