A Tale of Partition Schemes and Disappearing Dragons
A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.
2017-10-20 (first published: 2015-11-02)
4,336 reads
A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.
2017-10-20 (first published: 2015-11-02)
4,336 reads
2015-01-16
1,753 reads
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,529 reads
The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.
2013-04-11
2,684 reads
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
2013-02-21
6,683 reads
Arshad Ali provides a step-by-step guide to create a partitioned table/index.
2013-02-05
3,106 reads
Partitioning has improved with each new version of SQL Server. From partitioned views in SQL Server 7.0 through partition table parallelism in SQL Server 2008. With SQL Server 2012, we are now allowed to even create up to a 15K partition on a single table.
2013-01-03
4,975 reads
2012-11-02
2,677 reads
2011-09-16
2,155 reads
Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell
2014-03-21 (first published: 2010-12-28)
7,526 reads
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Ollama SQL FastStart kit just works out of the box. It makes it easy...
By Chris Yates
In today’s data-driven world, observability is not an optional add-on but a foundational principle....
Comments posted to this topic are about the item Create an HTML Report on...
Hello, Our old server is on its last legs, and I'm transitioning to a...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers