I'll add a :laugh: to that

The question appears to about how best to monitor log usage, and why the figure obtained from DBCC SQLPERF(LOGSPACE) sometimes goes over 100%.

As for the first part, while you certainly...

Steve Jones - Editor (9/3/2009)

---

Paul, I'd raise this issue again, and actually I'll make a note of it. They do update things, but it's a big book. I'm not surprised...

Bob ("evil and should be destroyed") and Jeff ("!enots ot gninrut") - you guys just rock!

So funny.

😀

Yes - although I would concede that 2005 and later are considerably better in that respect than...

Timothy & Randall,

You'll find the very fastest no-overhead method a few posts back (here).

Also:

1. It is true that, in the current versions of SQL Server, the QO will often...

Yeah, we've still got one 2000 box...and all this at a time when most are 2005, a small number are 2008, and we're busy evaluating the latest R2 CTP :laugh:

Oh I agree. But don't hold your breath for...

:laugh:

I...

Yikes!!!!

Not wrong as such, just not new.

We've kinda been down that track quite a bit in this thread already, you see?

Paul

Just for completeness, this is also valid:

-- Just to simulate some condition or other

declare @v-2 int;

set @v-2 = 2;

-- Dear Lord, why am I using a cursor here?

-- (probably an...

Hey Jack,

FILESTREAM support is pretty patchy - the list of core features that don't support it, or support it with caveats is long indeed.

Quite apart from the fact that the...

It might pay you to read back a few posts :laugh:

TheSQLGuru (9/3/2009)

---

I expect there to be lots of 'messes' out there related to MERGE and triggers. So incredibly difficult to follow some of the logic trees when both are...