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,294 reads
Partitioning
2015-01-16
1,752 reads
Table Partitioning –XE Diagnostic for Data Movements
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,522 reads
Partitioning in SQL Server: Managing Sliding Window Scenario
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
Filtered Indexes - Simple Partitioning without Enterprise Edition?
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
2013-02-21
6,667 reads
Partitioning in SQL Server - Part 3
Arshad Ali provides a step-by-step guide to create a partitioned table/index.
2013-02-05
3,106 reads
Partitioning in SQL Server
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,673 reads
2011-09-16
2,143 reads
Automate Sliding Window Partition Maintenance: Part III
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,491 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
Comments posted to this topic are about the item Shining a Light on Shadow...
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers