Download Episode (mp3)

Show 40!

During the show, we talk a little bit about Bob Marley, his songs and their meaning.

We also talk about:

Recommended bucket count for In-Memory OLTP

On Index rebuild, disable and statistics update

How the Datetime2 data type is stored

Various SQL Server tuning switches

Which operators can work in batch mode

AlwaysOn Availability Groups enhancements in SQL Server 2016

Async_network_io issues

The CXPacket and SOS_scheduler_yield wait types and what they mean