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:
'