December 2015 - SQLPerformance.com

Another Reason to Use NOEXPAND hints in Enterprise Edition

Posted by Paul White on December 30, 2015 3 Responses »

Dec 302015

Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.

Network Load Testing Using iPerf

Posted by Tim Radney on December 22, 2015 9 Responses »

Dec 222015

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.

SQL Server 2016 : Availability Group Enhancements

Posted by Aaron Bertrand on December 17, 2015 33 Responses »

Dec 172015

Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

Optimizing Update Queries

Posted by Paul White on December 16, 2015 3 Responses »

Dec 162015

Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals.

More showplan improvements? Yes, please!

Posted by Aaron Bertrand on December 8, 2015 No Responses »

Dec 082015

Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.

Partitioning on a Budget

Posted by Aaron Bertrand on December 4, 2015 5 Responses »

Dec 042015

Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.