In my experience, the difficulty is all in figuring out how to stack and nest the strings during construction so that it comes out the way it would if you...

Jeff Moden (1/3/2009)

---

Just a hint about speed... I've found that SQL Server and I both have a couple of things in common... we're both lazy and neither of us can...

Oh no, not for this kind of thing. For instance, this is rebuilding or reorging for each fragmented index that it finds, but there is still stuff that can...

Incredible result, Jeff. About once a week you post something that just blows me away.

And for the record, it wasn't the pseudo-cursor, the SELECT INTO or the FillFactor that...

Chris:

Heh. Not so much, nothing to test against.

And mine is only right if TimeKey can be assumed to be sequential (that is, without unintended gaps), otherwise you need...

Oops, Chris got in before me ... 🙂

Using a function like this in SQL at all in a query could lead to it's own performance problems, but this version is much faster, and about a zillion time...

Thanks. Yeah, error-handling is a bit of a pain, but I have done it with this approach and on much more difficult ones than this (changing databases, which throws...

Well, if I've learned anything from the movie Swordfish, it's that heavy...

repicurus (12/24/2008)

---

I believe that Abed misses or eludes the entire point / need for the occasional use of cursors, bad though they may be:

To loop through a record set...

Michael Artz (1/3/2009)

---

I guess you have nailed my prpblem as i am trying to do 2 things with this database/ program. Store Business Intelligence (formulae) and also record transactions ...records...

Hey, I really like that idea, Dugi!

You know, I'm not sure how much point there is to this particular exercise. 90% of the time is in the intiial scanning of the WebLogEvents table and as...

OK, here's my conversion of the MS example:

-- ensure a USE statement has been executed first.

SET NOCOUNT ON;

-- ensure the temporary table does not exist

IF EXISTS (SELECT name...

Heh. Happens almost every day, actually. 🙂