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 diffence between replicaion and logshipping?

1 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

What is the difference between an index and a unique index?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---