Which method should you use?
You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and SELECT statements.
You are tasked with providing a recommendation of indexes to be created and dropped from the database.
You need to select the appropriate method to accomplish the task.
Which method should you use?
Which tool should you use?
You need to capture and record a workload for analysis by the Database Engine Tuning Advisor (DTA).
Which tool should you use?
Which command should you use?
You are using the Database Engine Tuning Advisor (DTA) to analyze a workload. You need to save the recommendations generated by the DTA. Which command should you use?
Which Transact-SQL statement should you use?
You are troubleshooting query performance on SQL Server 2008. You have profiler trace data in a table named PerfData. You need to determine which events are taking longer than one second of CPU time or run for more than two seconds.
Which Transact-SQL statement should you use?
Which event should you use?
You are using SQL Server Profiler to gather deadlock information. You need to capture an XML description of a deadlock. Which event should you use?
Which Transact-SQL statement should you use?
You have run a server side trace that created 45 trace files. You want to load the trace files on your workstation in a database table called PerfData for further analysis. You need to load three files starting at c:my_trace_38.trc.
Which Transact-SQL statement should you use?
Which file extension should you use?
You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a graphical execution plan. You need to save the plan to a file that can be used by SQL Server Management Studio to display the graphical execution plan.
Which file extension should you use?
Which Transact-SQL setting should you use?
You are troubleshooting query performance on SQL Server 2008. You are tasked to create an estimated execution plan by using Transact-SQL. You should be able to view the plan graphically in SQL Server Management Studio. You need to ensure that the execution plan can be saved as a .sqlplan file.
Which Transact-SQL setting should you use?
Which statement should you use?
You need to capture the execution plan for a query. Which statement should you use?
Which Transact-SQL statements should you use?
You have a table named Customers that has an XML column named CustomerData. There are currently no indexes on the table.
You use the following WHERE clause in a query:
WHERE CustomerData.exist (‘/CustomerDemographic/@Age[.>="21"]’) = 1
You need to create indexes for the query.
Which Transact-SQL statements should you use?