How should you complete the stored procedure?

HOTSPOT
You are maintaining statistics for a database table named tbITransaction. The table contains more than 10 million records. You need to create a stored procedure that meets the following requirements
-On weekdays, update statistics for a sample of the total number of records in the table.
-On weekends, update statistics by sampling all rows in the table.
A maintenance task will call this stored procedure daily.
How should you complete the stored procedure? To answer, select the appropriate Transact-SQL segments in the answer area NOTE: Each correct selection is worth one point.
Hot Area:

microsoft-exams

One thought on “How should you complete the stored procedure?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.