Microsoft Exam Questions

You need to reduce the amount of time it takes to execu…

You have a SQL Server 2012 database named Database1.
You execute the following code:

You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?

A.
Option A

B.
Option B

C.
Option C

D.
Option D