While playing with this some more, I've noticed that the stmt_start and end will be 0 if the status is sleeping. The entry is still there because the connection...

What do you mean by "better"? Does this have the information you need, or are you looking for something more? Like, perhaps, the compression settings of the indexes...

You might also implement something using SET ROWCOUNT 50 or SET ROWCOUNT 100.

Should be similar to the cursor in that it wouldn't cause long term locking but doing it in...

I was thinking that as I was replying last time =). But it's screwy either way, because all the replies reference the whole not replying here thing, so if...

Not enough information to go on.

In general, the less rows you have to touch the better. So if the last table is large and the result of your aggregation...

I was thinking it persisted all your server settings and everything as well. Just installing SP1 in the same step doesn't really seem worth it for a one time...

Ninja's_RGR'us (4/9/2010)

---

Garadin (4/9/2010)

---

I am, but I know Jacob already...

Oops, had an extra HTTP in there. Fixed.

I am, but I know Jacob already has the...

No worries, it happens. We just try to pick one before everything gets fragmented.

Duplicate post, replies here please.

I'm debating playing with it too. I know Jack Corbett just wrote a couple posts about slipstreaming on his blog that I've been meaning to go back and read...

vktaylor (4/8/2010)

---

I tried you suggestion, but it returned the following message.

StartTime is invalid in the select list because it must be contained in an aggregate function or group...

If the situation is really as simple as your example, then you can check it with case statements... (Note: sorry, not on a SQL Server atm, so not tested)

DECLARE...

What a nice trip back through memory lane. You just made me dig back through oooold code to find this ;-). Yes kids, way back when, I actually...