Answer / flora

The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results

What is the difference between varchar and nvarchar?

0 Answers  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

What are the five major components of a dbms?

0 Answers  

---

Mention the differences between sql server and mysql.

0 Answers  

---

What is a transact-sql statement?

0 Answers  

---

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

How to define output parameters in stored procedures?

0 Answers  

---

Explain contrast amongst grouped and non-bunched records?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

What is stored procedure in SQL..??

2 Answers  

---