|
How to determine the service pack currently installed on SQL Server?
|
|
The global variable @@Version stores the build number of the sqlserver.exe, which is used to determine the service pack installed. eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
|
|
|
|
|
|
|
|
What is DTC (Distributed Transaction Coordinator) in SQL Server?
|
|
The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.
|
|
|
|
|
|
|
|
What are the OS services that the SQL Server installation adds?
|
|
MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)
|
|
|
|
|
|
|
|
What is an execution plan? When would you use it? How would you view the execution plan?
|
|
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very useful tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called “Show Execution Plan” (located on the Query drop-down menu). If this option is turned on it will display query execution plan in separate window when query is ran again.
|
|
|
|
|
|
|
|
Which virtual table does a trigger use?
|
|
Inserted and Deleted.
|
|
|
|
|
|
|