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 are different replication agents and what's their purpose? : sql server replication

0 Answers  

---

What is dirty page?

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What is the latest version of microsoft sql server?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

What are indexes in sql?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---