define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

What is optimization and its types?

0 Answers  

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

What is the most common trace flags used with sql server?

0 Answers  

---

---

What is tcl in sql server?

0 Answers  

---

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

How you can change a cross join into an inner join?

0 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---