Answer / Ankit Khare

{"Clustered Index": "A unique index that stores data in a specific order. Each table can have only one clustered index, and it determines the physical organization of data within the table.","Non Clustered Index": "An index that stores the data row identifiers (key values) along with some related data in a separate structure for faster query execution. Unlike clustered indexes, a table can have multiple non-clustered indexes."}

What are the benefits of normalization?

1 Answers  

---

What are the benefits of filtered indexes?

1 Answers  

---

Why are sql functions used?

1 Answers  

---

What is raid? : SQL Server Architecture

1 Answers  

---

What is faster join or union?

1 Answers  

---

What are the types of stored procedures in an sql server?

1 Answers  

---

What is tempdb database? : SQL Server Architecture

1 Answers  

---

Explain how many normalization forms?

1 Answers  

---

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

What is wide table?

1 Answers  

---

What is merge statement?

1 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

1 Answers  

---