Aaron Bertrand continues his series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.
Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.
Aaron Bertrand (@AaronBertrand) of SQL Sentry gives some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it doesn't play well with others.
I had a great time at the MVP Summit last week. Caught up with a lot of friends, tried some new foods (including Tempura Fried Kurobuta Bacon), and took in some great technical sessions.
