Category Archives: Partitioning

  1. Adding Identity to an existing column

    1

    June 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

  2. What’s in a partition?

    Leave a comment

    May 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

  3. Partitioning on a nullable column

    3

    May 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

  4. How do I change the increment of an identity column?

    2

    April 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

  5. Reload a table quickly.

    4

    November 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

  6. Scripting a partitioned table or index, a caution.

    14

    July 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013