Porter James

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.84 (44)

2017-10-20 (first published: 2015-11-02)

4,253 reads

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

When using Power BI and pulling data from Azure Synapse, you will use the...

There is a server running SQL Server 2012 32 bit. This is the default...

Hi Everyone, Currently looking at tidying up some SQL servers and i have a...

\hello Guys, Mayyou help wuth the corect index filetred creation using modulo? ...