Maximum number of supported Partitions in SQL 2014

  • Comments posted to this topic are about the item Maximum number of supported Partitions in SQL 2014

    Thanks.

  • Nice trivia, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?

  • Thank you for the post, good one.

    (I knew in SQL2012, it is 15K; so I was "assuming" that it might be same in 2014 too and also at the same I was thinking that "they might have increased the capability by few Ks"; then I thought "why anybody wants to create 15K partitions on a table? and they go saying "Oh God!! 15K is too less and I need few more Ks to complete it". Well choice selection of 15K was correct. 😀 )

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Michael_Garrison (1/16/2015)


    Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?

    I'm not sure he sleeps. 😉 Nice question.

  • Ed Wagner (1/16/2015)


    Michael_Garrison (1/16/2015)


    Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?

    I'm not sure he sleeps. 😉 Nice question.

    </joke>lets say he never sleeps... and he still gives 100% 24hours without break, such person is known as "vampire" (because of their strength and ability);.... Interesting.... a vampire who likes SQL..... well Stephenie Meyer just got a story for the next book</joke>

    postscript- please don't take this personally, (I am really not sure why I wrote this):-P

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 15K

  • isn't only 15k on 64-bit and 1k on 32-bit?

  • Raghavendra Mudugal (1/16/2015)


    Thank you for the post, good one.

    (I knew in SQL2012, it is 15K; so I was "assuming" that it might be same in 2014 too and also at the same I was thinking that "they might have increased the capability by few Ks"; then I thought "why anybody wants to create 15K partitions on a table? and they go saying "Oh God!! 15K is too less and I need few more Ks to complete it". Well choice selection of 15K was correct. 😀 )

    Are you saying Koen likes to wear glitter?

    (re: that glitter effect in the first movie was :sick: )

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question.

    ssimmons 2102 (1/16/2015)


    isn't only 15k on 64-bit and 1k on 32-bit?

    How many partitions it allows us to create on the 32-bit version isn't documented anywhere as far as I know, what we do know is that the number is more than 1000 (not 1000) but going above 1000, although it appears to be allowed up to some unknown number, is not supported. The QotD didn't aks how many were supported, but how many were possible.

    And then, even if the 32 bit version only allowed 1000, SQLS 2014 as a whole isn't limited by the capabilities of the 32-bit version.

    Tom

  • Michael_Garrison (1/16/2015)


    Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?

    +1, Same catch 🙂

  • Thanks for the question.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply