Category Archives: Index
-
Does a clustered index sort the rows within a page
Leave a commentDecember 15, 2014 by Kenneth Fisher
This is just something I was curious about. I ran my tests and got an answer and now I thought …
Continue reading -
DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD
2December 11, 2014 by Kenneth Fisher
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
Continue reading -
Using a date or int column as the clustered index.
9December 1, 2014 by Kenneth Fisher
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
Continue reading -
Adding a column to the primary key.
6November 13, 2014 by Kenneth Fisher
Every now and again you realize that the primary key for a table does not uniquely describe a row. Not …
Continue reading -
Force only certain values to be unique
1October 22, 2014 by Kenneth Fisher
I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
Continue reading -
Update to “The clustered index columns are in all of the non clustered indexes.”
4October 20, 2014 by Kenneth Fisher
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
Continue reading -
SchemaBinding – What & Why
6August 6, 2014 by Kenneth Fisher
What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
Continue reading -
The clustered index columns are in all of the non clustered indexes.
11July 30, 2014 by Kenneth Fisher
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
Continue reading -
DBA Myths: A table with a primary key is not a heap
5May 21, 2014 by Kenneth Fisher
Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
Continue reading -
DBA Myths: An index on a bit column will never be used.
4February 17, 2014 by Kenneth Fisher
Not true. (Or I guess probably wouldn’t be posting about it would I?) Probably the first thing I should point …
Continue reading
