I hope someone can offer me some insight. I am looking to partition a large table, using a datetime column, in an Azure SQL Database. We do not want to use Sharding.
I have the first parts of creating a partition function and partition scheme, and only using the primary filegroup (because that is all you have in Azure SQL Database), I will be partitioning to the left.
I am not sure of the correct terminology either, I am seeing 'sliding windows', and 'rolling windows', are both of these the same as switching? Are they the same, and the terminology is used interchangeably, or are they different?
This article is the closest I can get to what I am after,...(might come in handy for someone else)https://stackify.com/how-to-partition-tables-in-azure-sql/
...I wonder how different it is to implement partitioning on an Azure SQL Database, compared to partitioning on an Azure SQL Data Warehouse? I wonder if its basically the same, and therefore I can use articles on Azure Data Warehouse partitioning to help me out?
Any help or direction would be most appreciated. Thank you for reading.