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.

Create and insert into temp table in sql server?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

Explain the different types of joins?

0 Answers  

---

Explain a differential backup?

0 Answers  

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

What is acid db?

0 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

Is null vs coalesce?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---