Answer Posted / palpantian

A clustered index is a special type of index that reorders
the way records in the table are physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.

What is sql server programming?

1047

---

What happens if you add a new index to large table?

942

---

Does sql server 2016 have ssms?

963

---

What is recompile sql server?

1044

---

What is the difference between online clustering and Offline clustering?

2419

---

How can you list all the table constraints in a database?

939

---

Explain the flow of creating a cube? : sql server analysis services, ssas

1054

---

Explain the relational database management system (rdbms)?

1101

---

What are the two modes of authentication in sql server?

1070

---

Explain the microsoft sql server delete command?

1026

---

Which are new data types introduced in sql server 2008?

1054

---

How do I shrink an ldf file?

981

---

Do you know what is blocking?

967

---

Explain difference between cross join and full outer join?

1010

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1009

---