Excellent overview of Partitioning and Sliding-Window by Kimberly Tripp that provides background into why, how and technical implementation details.

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

I'm proposing the Scalable Shared Database architecture at my current client and will probably start a proof of concept shorty. I'm a little concerned that none of the BI...