Hehehe, I'm not a big fan of partitioned views, either. You also have to consider that for it to work efficiently you have to be able to segment your data somewhat uniformly and that's not always possible. However, it's out there as a possibility.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1