From Books Online: http://msdn.microsoft.com/en-us/library/ms189858.aspx

Reorganizing also compacts the index pages. Any empty pages created by this compaction are removed providing additional available disk space. Compaction is based on the...

And index reorg might be what you're looking for. It'll shuffle around the pages, condensing them and removing as much fragmentation as it can. Note that a reorg...

Yup, that's the sort of "home-grown" partitioning we've been talking about.

The other idea was to change the clustered indexes to try to physically seperate the inserts from the...

We retain 7 days of history. Right now the main table has around 40 million rows. Keep in mind that we won't have nearly as much data logged...

1. How many rows do you believe you'll delete at a time?

--> The database is a star schema. We'd delete around 6 million rows...

We've been talking a lot about partitioning, but we're running Standard Edt. and the business doesn't want to pay to Enterprise. We're kicking around some ideas on how we...

The structure of the page in memory is the same as a page on disk, but the information in the header is slightly different. The header is 96 bytes....