GilaMonster (10/10/2012)

---

Triggers use the version store. So do online index creation and rebuild.

dbasql79 (10/10/2012)

---

Isolation Level can be handled by session level also, not only database level, if I am right.

Is there any chance your application issue that?

Jeff Moden (10/8/2012)

---

Reads from the physical disk are always read into the "Buffer Pool". It's the reads from that "Buffer Pool" that SQL Profiler counts.

Perry Whittle (10/6/2012)

---

a logical read is the pages that are read in memory, a physical read is when the page is brought in from disk

SQLSACT (10/4/2012)

---

What I'm trying to understand is which of your resources are taxed the most when dealing with bad parameter sniffing

anthony.green (10/4/2012)

---

Uou need to capture then 1 second apart then minus the figures, as the counter value is cumulative.

db_expert_pradeep (10/4/2012)

---

When SQL engien traversing through Clustered index , the engine will start from Root page and traverse over non leaf nodes until it reaches leaf level page (data page).

GilaMonster (9/28/2012)

---

Unless you tested the same query you probably won't trigger any error. Not all queries need workspace memory.

Could it be this:

http://support.microsoft.com/kb/982854