Which code fragment should you use in each location in the command to complete one of the commands you will need to include in the job?

DRAG DROP

You need to create a job to automate some database maintenance tasks.

Which code fragment should you use in each location in the command to complete one of the commands you will need to include in the job? To answer, drag the appropriate lines of code to the correct locations in the command. Each line of code may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

View Answer

Answer:

Explanation:

UPDATE STATISTICS WITH FULLSCAN NORECOMPUTE

Update statistics by using FULLSCAN and NORECOMPUTE

The following example updates the Products statistics in the Product table, forces a full scan of all rows in the Product table, and turns off automatic statistics for the Products statistics.

USE AdventureWorks2012;

GO

UPDATE STATISTICS Production.Product (Products)

WITH FULLSCAN, NORECOMPUTE;

GO