Category Archives: Partitioning
-
Adding Identity to an existing column
2June 19, 2017 by Kenneth Fisher
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
Continue reading -
What’s in a partition?
Leave a commentMay 22, 2017 by Kenneth Fisher
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit …
Continue reading -
Partitioning on a nullable column
3May 3, 2017 by Kenneth Fisher
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add …
Continue reading -
How do I change the increment of an identity column?
7April 5, 2017 by Kenneth Fisher
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
Continue reading -
Reload a table quickly.
6November 21, 2016 by Kenneth Fisher
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
Continue reading -
Scripting a partitioned table or index, a caution.
14July 15, 2013 by Kenneth Fisher
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
Continue reading
SQL Studies 