(Serdar Yegulalp) Index partitioning is one of a number of new features introduced in SQL Server 2005 as a way to distribute the load for a given index across multiple files, which can enhance parallelism or improve index performance in other ways. (R)
Read More - Register for Free Membership
