You use SQL Server. The physical server is a dedicated database server that has 120GB of RAM available. There is approximately 50GB of storage space available on a slow local disk.
You create a new stored procedure. You decide you need to temporarily hold approximately 300,000 rows from two tables, from which you will compute two complex business scores.
The stored procedure will use temporary storage defined as follows:
The code will make several passes through the data, applying complex calculations before writing the data to a permanent disk-based table in the same database from which it reads the data.
For this stored procedure, you need to deal with temporary data in the most efficient way to minimize physical disk pressure.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
You Use Sql Ser 1 (7.85 KiB) Viewed 107 times
You Use Sql Ser 2 (57.65 KiB) Viewed 107 times
A. Option A
B. Option B
C. Option C
D. Option D
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!