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,246 reads

Another post for me that is simple and hopefully serves as an example for...

If you’re like me, your palms went into a cold sweat to get your...

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

Hello SQL experts, Please see attached file for table detail. I have a temp...

Hello. Does anyone know how I can retry a job should any one of...

I have a table which stores shipment data by date. We have a need...