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.