July 2015 - SQLPerformance.com

Proactive SQL Server Health Checks, Part 4 : ERRORLOG

Posted by Erin Stellato on July 30, 2015 5 Responses »

Jul 302015

Erin Stellato (@erinstellato) describes the value of the SQL Server error log in her ongoing series about proactive health checks.

Improving the Row Numbering Median Solution

Posted by Paul White on July 28, 2015 2 Responses »

Jul 282015

Paul White (@SQL_Kiwi) takes another look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.

Locking and Performance

Posted by Paul White on July 20, 2015 1 Response »

Jul 202015

Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.

Our new SQLPerformance.com Newsletter

Posted by Aaron Bertrand on July 15, 2015 2 Responses »

Jul 152015

We have launched a new, bi-weekly newsletter to offer you the freshest content from our blogs and beyond. Subscribe at: https://SQLSentry.com/community.

Calculating the Median with a Dynamic Cursor

Posted by Paul White on July 15, 2015 No Responses »

Jul 152015

Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.

The Importance of Maintenance on MSDB

Posted by Tim Radney on July 10, 2015 12 Responses »

Jul 102015

Tim Radney (@tradney) discusses some aspects of the msdb database that probably require more attention than they currently get in a lot of environments.