Answer / Navneet Aryan

A database index is a data structure that improves the speed of data retrieval operations on a database table. It works similarly to an index in a book, allowing SQL Server to quickly locate and retrieve rows that match the search condition without having to scan the entire table.

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1 Answers  

---

What is collation sensitivity? Explain different types.

1 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

Define the one-to-one relationship while designing tables.

1 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

What is row_number () and partition by in sql server?

1 Answers  

---

What are the two types of concurrency?

4 Answers  

---

How connect excel to sql server?

1 Answers  

---

What is the difference between resultset and resultsetmetadata?

1 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1 Answers  

---

What are the default system databases in sql server 2000?

1 Answers  

---

What is the default order of an order by clause?

1 Answers  

---