56,966 blogs · 4,417,066 posts Claim your blog

Record · corpus.blog/posts/01a087e4-b040-70cb-9155-2957ef4fcab9

It's Time to Break Up with Archive Tables

sqlblog.org · published 27 July 2026

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at sqlblog.org Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
Links from this post: 13
Words captured: 2,202

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://sqlperformance.com/wp-content/uploads/2026/07/archive-table-featured.png

sqlperformance.com

SQL Server at Scale – Using an archive table, Part 1 Read at the source ↗

SQL Server at Scale – Using an archive table, Part 2 Read at the source ↗

SQL Server at Scale – Using an archive table, Part 3 Read at the source ↗

https://www.timradney.com/rethinking-index-maintenance-why-avg_fragmentation_in_percent-is-outdated-and-what-you-should-do-instead/

timradney.com

https://sqlperformance.com/wp-content/uploads/2026/07/row-by-row.gif

sqlperformance.com

https://sqlperformance.com/wp-content/uploads/2026/07/monthly-swap.gif

sqlperformance.com

https://techcommunity.microsoft.com/blog/modernizationbestpracticesblog/part-2---azure-sql-db-hyperscale-table-partitioning---best-practices--recommenda/3721453

techcommunity.microsoft.com

https://www.cathrinewilhelmsen.net/table-partitioning-in-sql-server-partition-switching/

cathrinewilhelmsen.net

https://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

mssqltips.com

https://mrfoxsql.com.au/2015/06/10/rebuilding-existing-partitioned-tables-to-a-new-partition-scheme/

mrfoxsql.com.au

https://www.brentozar.com/archive/2016/09/partitioned-views-guide/

brentozar.com

https://sqlperformance.com/2015/12/sql-indexes/partitioning-on-a-budget

sqlperformance.com