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.

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

Why use update_statistics command in sql server?

0 Answers  

---

What is a database table?

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

What is 3nf normalization form?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---