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 *