Answer / sumit

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.

What is sql sandbox in sql server?

0 Answers  

---

What is table-valued sub query?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What are the transaction properties?

0 Answers  

---

What do you mean by authentication modes in sql server?

0 Answers  

---

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What do you mean by an execution plan?

0 Answers  

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

how to do partition in sqlserver

0 Answers   TCS,

---