John Mitchell-245523 (5/9/2011)

---

I discounted Page splits/sec because page splits are also caused by INSERT statements, and therefore if you wanted to measure the rate at which UPDATE statements cause data to be moved, you may get some misleading results.

Have I missed something, or did I misread the question?

John

Steve Jones - SSC Editor (5/9/2011)

---

Hard to tell here. I did ask for movement because of size differentials. I suppose an insert could be argued to cause this and I'll concede here. I've altered the question to say insert and update.

Steve Jones - SSC Editor (5/9/2011)

---

Hard to tell here. I did ask for movement because of size differentials. I suppose an insert could be argued to cause this and I'll concede here. I've altered the question to say insert and update.

Peter Trast (5/9/2011)

---

We have had alot of really good questions the last few weeks, although I am not sure if questions that DON'T start a debate are really so great after all :)

SanDroid (5/9/2011)

---

LOL Peter... did you foget the j/k after that?
Seriously though I have to agree.
Being able to debate and prove an answer or statement is correct without using misquoted data or invalid jumps in logic is very important when teaching professional adults.

My MCT course had a statement that stuck with me;
"Children will believe in anything, Adults require some proof."

Steve Jones - SSC Editor (5/9/2011)

---

While you are correct that page splits do not occur for heaps, it also means that there is no movement to new pages. This isn't pages used for data, the question asked for pages on which data is moved.