If it were an index, then why would the database scan every record in a heap when you were searching for...

Dennis Q Miller (12/27/2012)

---

The "doubling" you experienced is symptomatic of adding a clustered index with a 50 percent fill-factor to a table with little free space. When the clustered...

timothyawiseman (12/26/2012)

---

Thank you for providing the article. It does provide a simple explanation for people new to the subject. But I think it should be pointed out (preferrably...

Divine Flame (12/26/2012)

Nice article, Hakim :-).

However I am fine with the terms "table [has] a clustered index". A table is always a table no matter it has any index...

Dennis Q Miller (12/26/2012)

---

To say a table "is" a clustered index is specious, at best. I suppose you might approximate truth by saying the table "is" the leaf nodes...

hakim.ali (12/24/2012)

---

Exactly. So, a clustered index really is an index that makes the table "appear" to be physically ordered by the index value. The data is not actually...

Exactly. So, a clustered index really is an index that makes the table "appear" to be physically ordered by the index value. The data is not actually physically...

DaleB (12/24/2012)

---

I find this hard to believe. If I have a table with 50 million rows, is SQL really going to move all those down one space to insert...

Thanks much, you just made my...

annjunk (12/24/2012)

---

I wonder if this over simplification will end up confusing people more in the end. Both clustered and non-clustered indexes have what are called non-leaf-level pages that can...

Mr. hoek (12/24/2012)

---

But why does the table allocation 'double' when adding a clustered index?

The only explanation I can think of, is that SQL server has the information 'twice' in the...

annjunk (12/24/2012)

---

patrickmcginnis59 (12/24/2012)

---

Let's assume there is no clustered index on this table. This makes it a heap, meaning the rows are not physically written to disk in any particular order....

Thank you for pointing that out. Another reason...

Gracias.

roger.plowman (12/24/2012)

---

Mr. hoek (12/24/2012)

---

It would be nice that MSSQL tables would 'be' clustered or non clustered, but in fact they 'are' heaps with an optional 'clustered index' added to then.

Removing...