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.

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---

What the different components of Replication and what is their use?

0 Answers  

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

What is data block and how to define data block size?

0 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

How to enter binary string literals in ms sql server?

0 Answers  

---

How do I perform an unattended install of sql server 2000?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

What are the different authentication modes in sql server?

0 Answers  

---