Sql Server

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