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?

You are working with a SQL Server 2008 instance that is configured to use the Latin1_General_CS_AS collation. You create a database by using the following statements.

CREATE DATABASE TestDB COLLATE Estonian_CS_AS;
GO
USE TestDB;
GO
CREATE TABLE TestPermTab (PrimaryKey int PRIMARY KEY, Col1 nchar );

You implement a temporary table named #TestTempTab that uses the following code.

use TestDB;
GO
CREATE TABLE #TestTempTab (PrimaryKey int PRIMARY KEY, Col1 nchar );
INSERT INTO #TestTempTab
SELECT * FROM TestPermTab;

You need to identify which collation will be assigned to #TestTempTab. Which collation will be assigned?

You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports.
You need to force a query to use only one processor core without affecting other queries.
Which option should you use?

You have a table named JobCandidate. You are tasked to delete a row in the JobCandidate table. You need to write a transaction that allows the database to be restored to the exact point the record was deleted without knowing the time of execution. Which query should you use?