Category Archives: Index
-
Natural vs Artificial Primary Keys
6August 29, 2016 by Kenneth Fisher
There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
Continue reading -
Remove files from a filegroup
Leave a commentMay 2, 2016 by Kenneth Fisher
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve …
Continue reading -
Pulling data from a non-clustered index
2March 14, 2016 by Kenneth Fisher
This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
Continue reading -
To the page and back again
1January 18, 2016 by Kenneth Fisher
To the page It’s not one of those things you have to do frequently but every now and again you …
Continue reading -
Using unique constraints
10December 10, 2015 by Kenneth Fisher
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was …
Continue reading -
Filtered Index restrictions and Kendra Little’s Index Quiz
3July 20, 2015 by Kenneth Fisher
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had …
Continue reading -
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
6December 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.
13December 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.
13November 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
SQL Studies 