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

While I always configure transaction log backups for every database in non-simple recovery model,...

There’s a video of Bill Gates taking a drive in an autonomous car around...

It is common to see high worker count issue on the production server and...

Comments posted to this topic are about the item Has SQL Server Performance Improved?

I want to align a Date column (datetime2(7)) with the same full resolution date...

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...