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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

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