Some of my favorite articles originally appearing at SQLPerformance.com.Why Not Seek PredicatePaul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due ...

 Some of my favorite articles originally appearing at SQLPerformance.com.   Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing DuplicatesIn these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways ...

Some of my favorite articles originally appearing at SQLPerformance.com. Dirty Secrets of the CASE ExpressionAaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and ...

Some of my favorite articles originally appearing at SQLPerformance.com. Read Committed Snapshot IsolationPaul White ( b | t ) has been doing a phenomenal series on SQL Server behavior under each of the major isolation levels. This particular post details the inner workings of READ COMMITTED SNAPSHOT, but there ...

Some of my favorite articles originally appearing at SQLPerformance.com. Avoiding Knee-Jerk Performance TuningPaul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue.Knee-Jerk Wait Statistics: ...

Me and Aaron Bertrand, SQL Sentry flagbearers.One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line:Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ...