Show 12 – The Other One Mode

Download Episode (mp3)
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:

Leave a Reply