Interview Questions
1. How merry-go-round scanning is associated with SQL Server?
n SQL Server Enterprise Edition, the advanced scan feature allows multiple tasks to share full table scans. If the execution plan
of a Transact-SQL statement requires a scan of the data pages in a table and the Database Engine detects that the table is already
being scanned for another execution plan, the Database Engine joins the second scan to the first, at the current location of the
second scan. The Database Engine reads each page one time and passes the rows from each page to both execution plans. This
continues until the end of the table is reached.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment