Another Reason to Use NOEXPAND hints in Enterprise Edition Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition. Paul White ◆ December 30, 2015 6
Network Load Testing Using iPerf Tim Radney (@tradney) of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue. Tim Radney ◆ December 22, 2015 9
SQL Server 2016 : Availability Group Enhancements Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016. Aaron Bertrand ◆ December 17, 2015 45
Optimizing Update Queries Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals. Paul White ◆ December 16, 2015 3
More showplan improvements? Yes, please! Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general. Aaron Bertrand ◆ December 8, 2015 0
Partitioning on a Budget Aaron Bertrand walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag. Aaron Bertrand ◆ December 4, 2015 6