You have a server that runs SQL Server 2008 Standard. The server provides data storage
for a thirdparty contact management application. A service-level agreement for the
application does not allow for modifications to be made to the application or to the database
objects used by the application. You need to recommend a strategy to mitigate performance
issues. The strategy must minimize database growth. What should you recommend?
A.
plan guides
B.
partitioned tables
C.
a scalable shared database
D.
clustered indexes