Point Out The Correct Statement #782
Point out the correct statement.
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Performance Tuning and Optimization - Indexing Strategies - Quiz No.2.
Point out the correct statement.
When SORT_IN_TEMPDB is set to OFF, the default, the sort runs are stored in the source filegroup
The Database Engine first scans the data pages of the base table to retrieve key values and builds an index leaf row for each data row
When SORT_IN_TEMPDB is set to ON, the default, the sort runs are stored in the destination filegroup
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
