rashton (11/16/2011)

---

Admittedly, getting it right may have biased my opinion, but I have to say that this is possibly the best QotD I've tried so far so please, more like this Hugo!

I would also mention that having done the calculations by hand, I double-checked them by running the code (I used the numbers 1 to 1000000 from a tally table in another DB I keep on hand for the PK column values) then using this query:

SELECT SUM(page_count)
FROM sys.dm_db_index_physical_stats
(
	DB_ID(),
	OBJECT_ID('DemoTable'),
	NULL,
	NULL,
	'DETAILED'
);

Since you specified SQL Server 2005 and up in the question, I figured it was a good way of highlighting how the Dynamic Management Views can help us work these things out.

Hugo Kornelis (11/16/2011)

---

My question is: would you like a few more questions of this kind, or would submitting the rest of the questions I was planning expose me to death threats, stale fruit, or lots of boo-ing and hissing?
This is a serious question. If the majority feels that the QotD should not involve that much work, I will not submit the other similar questions I was planning.