Answer / Vinay Kumar Sahu

1. Index: A database object that improves the speed of data retrieval by organizing data in a specific order.
2. Clustered Index: A type of index that sorts data physically, with only one clustered index per table. It is used as the primary key.
3. Nonclustered Index: A secondary index that does not sort data physically. It can be created for multiple columns and has a separate data structure.

How to find which stored procedure is currently running in sql server?

1 Answers  

---

What is change tracking in sql server?

1 Answers  

---

How to sort the query output with order by clauses in ms sql server?

1 Answers  

---

What is a unique index?

1 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1 Answers  

---

What are the advantages of using stored procedures in sql server?

1 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

why would you call update statistics? : Sql server database administration

1 Answers  

---

Difference between report and query parameter.

1 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---