• Hi,

    Thanks for your encouragement. Here are some pointers which might be helpful for you on table and index partitioning as well as on Filtered Index of SQL Server 2008.

    Partitioned Tables and Indexes in SQL Server 2005

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

    Partitioned Table and Index Strategies Using SQL Server 2008

    http://msdn.microsoft.com/en-us/library/dd578580.aspx

    Filtered Index of SQL Server 2008

    http://www.mssqltips.com/tip.asp?tip=1785

    With Thanks and Regards
    Arshad Ali
    Microsoft India

    My Blog - http://arshadali.blogspot.com/[/url]