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?

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?

You need to capture the execution plan for a query. Which statement 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?

You have an XML schema that you must use to validate XML data in your database. You need to store this XML schema. Which code segment should you use?

Your company exchanges information with other companies by using XML and Web services. Your manager asks you to remove a schema collection that is no longer used. Before dropping the schema, you should confirm that it is no longer in use.
You need to use a catalog view to determine if the schema collection is being used. Which catalog view should you use?

You have a table named Products.Product. The table has columns ProductID, Name, Size, and Category.
You have a variable named @XML with following XML value:

<Root>
<Category Name="Socks" />
<Category Name="Pants" />
<Category Name="Shirts" />

</Root>

You are tasked to write a query that lists the products in Products.Product that match the categories listed in the XML document. You need to write a query to accomplish the task. Which query should you write?