Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.
Continue Reading »Nov 302015
Nov 242015
Dan Holmes (sql.dnhlms.com) talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
Continue Reading »Nov 202015
Glenn Berry (@GlennAlanBerry) discusses a new feature in Windows Server 2016, Storage Spaces Direct, and how SQL Server will benefit.
Continue Reading »Nov 122015
Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
Continue Reading »Nov 032015
Paul White (@SQL_Kiwi) discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash joins.
Continue Reading »