In part 3, I show how to automate creating new tables, dropping old tables, and adjusting the view.
Monthly Archive: November 2022
In part 2, I look at general strategies for partitioning an archive table (even without Enterprise!) to reduce long-term data movement.
For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality."
Over a decade of posts and videos involving bad habits and best practices in SQL Server.
In this series, I look at strategies for archiving data and how it can impact your entire infrastructure.