What should you do?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *