Viewing 15 posts - 106 through 120 (of 162 total)
patrickmcginnis59 (12/28/2012)
Sounds like a pretty efficient index to me 🙂
If it were an index, then why would the database scan every record in a heap when you were searching for...
December 28, 2012 at 12:44 pm
Dennis Q Miller (12/27/2012)
December 27, 2012 at 10:17 am
timothyawiseman (12/26/2012)
December 26, 2012 at 7:00 pm
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...
December 26, 2012 at 8:11 am
Dennis Q Miller (12/26/2012)
December 26, 2012 at 8:02 am
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...
December 24, 2012 at 8:25 am
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...
December 24, 2012 at 8:22 am
DaleB (12/24/2012)
December 24, 2012 at 8:16 am
ljwitner (12/24/2012)
The best post I have read in awhile! I hope you will contribute more. I will look for you on the net!
Thanks much, you just made my...
December 24, 2012 at 7:54 am
annjunk (12/24/2012)
December 24, 2012 at 7:53 am
Mr. hoek (12/24/2012)
The only explanation I can think of, is that SQL server has the information 'twice' in the...
December 24, 2012 at 7:51 am
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....
December 24, 2012 at 7:48 am
Phil Parkin (12/24/2012)
Nice article, but rather than fields and records, I think you really mean columns and rows - there is a difference.
Thank you for pointing that out. Another reason...
December 24, 2012 at 7:46 am
dfortier (12/24/2012)
Finally, an explanation that does not require mental gymnastics and reading between the lines. Thanks for taking the time.
Gracias.
December 24, 2012 at 7:44 am
roger.plowman (12/24/2012)
Mr. hoek (12/24/2012)
Removing...
December 24, 2012 at 7:43 am
Viewing 15 posts - 106 through 120 (of 162 total)