Sample Header Ad - 728x90

What methods exist for partitioning a multi-terabyte table on Standard Edition without hours of down time?

0 votes
3 answers
300 views
Much of what I find online about partitioning large tables is very old. Databases are larger now and the old methods rarely account for the constraints of Standard Edition (partitioning was Enterprise only until 2016). This question exists to find modern methods of partitioning large tables on Standard Edition. I have the following constraints. What methods exist for satisfying them on Standard Edition? - 2 TB table. To keep things simple, assume that it has one ascending primary key and no other indexes/constraints/triggers. - Must be partitioned - The end of the table is hot. The rest is not. - Standard Edition, so RAM and online operations are limited - SQL Server 2022 - No data loss allowed - Minimal down time allowed. 20 minutes at most. This likely rules out partitioning the table in place. - Optimistic locking of any kind is not enabled - This process can be done slowly, e.g. over weeks.
Asked by J. Mini (1237 rep)
Dec 23, 2024, 10:34 PM
Last activity: Jan 2, 2025, 03:51 PM