Show 12 – The Other One Mode
Show 12 is here, and yet again we have a mix of various SQL Server topics. Among them are High Availability, development, performance, Columnstore Indexes, Azure, and general news and events. More specifically, we talk about: How log backup and Log Shipping really work What parts of SQL Server Memory does the Max Server Memory option controls Performance differences between Row_Number and CROSS APPLY A disturbing bug with the SYSDATETIME function Clustered Columnstore Indexes, and how Rebuild and Reorganize work on them Azure Storage SQLRally and SQLBits conferences And more.. Items mentioned in the show: Guy Glantser – SQL Server Developer Tips that Can Save Your XXX Matan Yungman – Rebuilding and Reorganizing Clustered Columnstore Indexes Kendra Little – Did You Give SQL Server 2012 Standard Edition Enough Memory? Glenn Berry – Running SQL Server 2014 on an Azure Virtual Machine Mary Jo Foley – Microsoft says Storage service performance update brought Azure down Azure Premium Storage