Explanation:The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. 8. SQL Server 2008 provides enhanced partitioning information for __________ execution plans.
A. compile-time
B. run time
C. both compile-time and run-time
D. All of the mentioned
Answer:A
Explanation:The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. 8. SQL Server 2008 provides enhanced partitioning information for __________ execution plans.
A. compile-time B. run time C. both compile-time and run-time D. All of the mentioned
Explanation:Execution plans now provide an optional Partitioned attribute that indicates that an operator, such as a seek, scan, insert, update, merge, or delete, is performed on a partitioned table. 9. Which of the following partitioned attribute can appear in the following physical and logical operators ?