Is your anti-virus completely up to date?

So...did you solve it? Was it a trigger?

Ok, thanks for the feedback.

Lynn Pettis (3/20/2010)

---

Yes, READ UNCOMMITTED can be the right choice for many applications, the problem comes when it is selected and it isn't appropriate and people start complaining about inaccurate...

:blink: I had just about finished mine when I saw the new posts. Gah!

Oh well, it was too much work to not post it, so here it is:

Setup

DECLARE @Table

TABLE...

Kevin Bullen (3/20/2010)

---

I am running the job in production today with statistics profile & io on, so i can post the execution plan and io stats for both prod and...

An implementation using hierarchyid:

Setup:

USE tempdb;

GO

IF OBJECT_ID(N'dbo.Tree', N'U')

IS NOT NULL

DROP...

The second result just contains the return code from the procedure. I believe this to be a...

And, at the risk of going on about this, READ COMMITTED can increase CPU usage by 50% compared to READ UNCOMMITTED, see http://sqlblog.com/blogs/alexander_kuznetsov/archive/2008/07/12/cpu-overhead-for-higher-isolation-levels.aspx.

READ UNCOMMITTED gets a bad press. It...

GilaMonster (3/19/2010)

---

This is the...

Dave Ballantyne (3/19/2010)

---

I like...

Did you read the BOL links?

Jason,

Seems to be, but I agree it would be interesting to see the plan...

Very nice Ron!

Can't believe anyone is still using 2000 though 😉 😛

(Please no-one take that statement seriously - thanks)

CirquedeSQLeil (3/19/2010)

---

That would be nice and all -...