Your SQL Server 2005 database contains a table that has 500?million rows of data. Some of the data is
historical and some is current.
You need to partition the data on a single server to increase performance and optimize maintenance.
What should you do?
A.
Implement horizontal partitioning.
B.
Implement vertical partitioning.
C.
Implement a raw partition.
D.
Implement distributed partitioning.