Answer / Rakesh Ray

"A clustered index sorts data in the table itself, while a non-clustered index stores the indexed columns as a separate structure."

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Is sql server difficult to learn?

1 Answers  

---

What is the difference between left and right outer join?

1 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

1 Answers  

---

How to create a simple user defined function in ms sql server?

1 Answers  

---

What are the database objects? : SQL Server Architecture

1 Answers  

---

What is the optimization being performed in oracle and SQL Server?

1 Answers   Cap Gemini,

---

difference between Clustered index and non clustered index ?

1 Answers   Infosys,

---

When I delete any data from a table, does the sql server reduce the size of that table?

1 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

1 Answers  

---

What are the 10 characteristics of data quality?

1 Answers  

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1 Answers  

---