SQL Performance Archives - Page 17 of 31

Service Broker Enhancements in SQL Server 2016

Aaron Bertrand (@AaronBertrand) shows some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.

Aaron Bertrand ◆ October 26, 2015

1

Knee-Jerk Wait Statistics : PAGELATCH

Paul Randal (@PaulRandal) adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.

Paul Randal ◆ October 19, 2015

4

Maintaining a grouped running MAX (or MIN)

SQL Sentry's Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.

Aaron Bertrand ◆ October 8, 2015

0

Proactive SQL Server Health Checks, Part 5 : Wait Statistics

Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.

Erin Stellato ◆ October 1, 2015

4

Practical Processor Selection for SQL Server 2014/2016 OLTP Workloads

Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.

Glenn Berry ◆ September 15, 2015

2

Interesting things about INSTEAD OF triggers

Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.

Paul White ◆ September 11, 2015

10

More on CXPACKET Waits: Skewed Parallelism

Paul Randal (@PaulRandal) explains how to tell when CXPACKET waits are actually a problem (because, usually, they are just an indication of parallelism).

Paul Randal ◆ August 26, 2015

9

Improving the Top / Top Descending Median Solution

Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some […]

Paul White ◆ August 6, 2015

2

Proactive SQL Server Health Checks, Part 4 : ERRORLOG

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

Erin Stellato ◆ July 30, 2015

5

Improving the Row Numbering Median Solution

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.

Paul White ◆ July 28, 2015

2

Locking and Performance

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

Paul White ◆ July 20, 2015

1