brazumich (11/15/2011)

---

Good question, thank you.

I will "third" liking your question format. It forces us to actually type the code if we want to cheat that way before answering the question.

Or...

You...

Grant Fritchey (11/15/2011)

---

Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through all this....

I'd wait at least 1 month before choosing to drop anything. End of month or anything might need those.

System usage is still usage BTW.

Aside from the 2 he already posted and which you forgot to read?

We don't see your picture. Attach it to the thread or another server.

Start with never use it assuming you care about data quality and you'll be better off.

There are very specific case uses but they are rare.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

SQL Kiwi (11/15/2011)

---

Brandie Tarvin (11/15/2011)

---

Does this mean SQL 2008 (regular) will never show...

I just can't tell you what's happening without seeing both actual plans.

Ever tried to get your car fixed without taking it to a mechaninc? Pretty much same thing here...

No snapshot isolation uses the row version store in tempdb to read the last "valid" version of the row while an update occurs in the base table. That way...

Grant Fritchey (11/15/2011)

---

Excellent...

Same here.

No offense if I forgot anything else. I didn't reread the whole 2 weeks either :hehe:.

I do the backups locally, on a 2nd san. In a shared folder and then immediately kick in a test restore.

So I know right away if anything went wrong......

Any reason why you're no using snapshot isolation?

😀

1 loop would have been enough, but...