After building you new database server you load on a large magazine article archive database with hundreds of millions of records. The records are organized by the date the magazine article was published, and spans for 20 years. The end users are complaining of slowness problems when they do lookups. Your server is max'd out in database optimization, indexing, controller caching, server memory, processor speed, disk optimization, etc. Furthermore, you are not allowed to upgrade. Most of the queries run on only the past year. Choose the best of the following solutions that would help optimize the search process. Bear in mind you must keep all the data available
A) Archive a bunch of the data to CD or DVD and put it in a jukebox library server.
B) Install a load-balancing appliance.
C) Create triggers that will perform database defragmentation each time a search is performed.
D) Divide your database into year-based segments and employ database federation by creating partitioned views.
You are a database developer for one of those annoying companies that conducts telephone surveys. As the survey responses are received from the people conned into participating, they are entered into a table named Responses. After all of the responses to a survey are received, summaries of the results are produced. You have been asked to create a summary by using a sampling method of pulling every fifth row of the table of responses. You need to produce the summary as quickly as possible. What should you do?
A) Use the SELECT TOP (1, modulo 5, recurse) statement to retrieve the desired data.
B) Set the query Rowcount to five and run a regular select statement.
C) Create a cursor to retrieve all of the data for the survey. Use the FETCH RELATIVE 5 statement to select the summary data from the cursor.
D) Use a SELECT TOP 5 statement to retrieve and summarize the survey data.