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-SOL segments in the answer area. NOTE: Each correct selection is worth one point.

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-SOL segments in the answer area. NOTE: Each correct selection is worth one point.

Answer: