Home Forums Cloud Computing SQL Azure - Administration Table partitioning on Azure SQL Database (not sharding), I'm after a rolling/sliding window solution based on DateTime column. RE: Table partitioning on Azure SQL Database (not sharding), I'm after a rolling/sliding window solution based on DateTime column.

  • October 10, 2017 at 12:39 am

    #1962942

    First of all: the concepts: https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning

    Did you have a look at : https://www.mssqltips.com/sqlservertip/3494/azure-sql-database--table-partitioning/ ?

    I haven't tested this on a Azure SQLDB, but this seems worth the try, since it also handles the trunctate of a partition ! (and is quiet recent ) https://stackify.com/how-to-partition-tables-in-azure-sql/

    Don't start it if you don't master it !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me