Show 12 The Other One Mode

Published: Dec. 17, 2014, 9:21 a.m.

b'

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\\xa0parts of SQL Server Memory does the Max Server Memory option controls
  • Performance differences between Row_Number and CROSS APPLY
  • A\\xa0disturbing bug with the SYSDATETIME\\xa0function
  • Clustered Columnstore Indexes, and how Rebuild and Reorganize work on them
  • Azure Storage
  • SQLRally and SQLBits\\xa0conferences
  • And more..

Items mentioned in the show:

'