Horizontal partitioning separates rows by key fields; for example, all Arizona records are maintained in one index and New Mexico records in another, etc., or account numbers from 00001 to 49999 in ...
Data Partitioning is a very useful feature in SQL Server 2005 and beyond. I have discussed this database feature in previous blog entries but it is also available in SQL Server Analysis Services which ...