Post reply

Is table partitioning available in azure sql server?

  • November 18, 2014 at 12:09 am

    #312708

    Hi There

    can we implement the vertical table partitioning in azure sql server ?

    Please share me the links to learn.

  • November 18, 2014 at 1:26 am

    #1759162

    Horizontal partitioning is just having multiple tables each storing part of the data with a view 'merging' them.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 22, 2014 at 9:27 am

    #1760344

    You can, but it's not at all the same partitioning mechanisms available in the earthed product. Here's some sample code on how to set it up from Microsoft. Here's a discussion on things to take into consideration from Microsoft. It's a non-trivial problem, but, SQL Database is actually designed around doing this sort of thing.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

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