SQL Server 2016 : In-Memory OLTP Enhancements Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016. Aaron Bertrand ◆ November 30, 2015 32
Custom Built Statistics 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. Guest Posts ◆ November 24, 2015 1
Introduction to Storage Spaces Direct for SQL Server Glenn Berry (@GlennAlanBerry) discusses a new feature in Windows Server 2016, Storage Spaces Direct, and how SQL Server will benefit. Glenn Berry ◆ November 20, 2015 6
Please help improve SQL Server statistics! Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics. Aaron Bertrand ◆ November 12, 2015 1
Hash Joins on Nullable Columns Paul White (@SQL_Kiwi) discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash joins. Paul White ◆ November 3, 2015 18