June 18, 2018 at 12:39 pm
Hi All,
Is Data partitioning is supported on Azure SQL database (PaaS db)?
As per my knowledge, filegroups are not supported on Paas db. Is that correct? or is there a way to implement partitioning on azure sql db.
Thanks,
Sam
June 19, 2018 at 2:31 am
Partitioned views and traditional partitioning are not supported because Azure SQL Database implements the PaaS offering differently. However, lots of people do logical partitioning with Azure SQL Database letting the code handle the partitioning aspect and the database just handling the storage. Basically, instead of what you're thinking of as partitioning, there is a different database for each "partition" and the code figures out which one to hit for data access.
"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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply