Quiz 70-464, Developing Microsoft SQL Server 2012 Databases
You need to reduce the amount of time it takes to complete the query
You need to create a trigger that supports the following requirements:
You need to set up the Resource Group and Workgroup Pools on the instance
Which two statements can you make about the performance characteristics of this query?
Which code segment should you execute before you remove Column1?
Which statement or statements should you execute?
Which dynamic management objects should you identify?
What three tasks should you perform next?
What should you create?
How should you complete the table definition to reduce contention on the table structure?