Tag : SQLPerformance.com - SentryOne Team Blog

Tag: SQLPerformance.com

SQLPerformance.com – same great content, new skin!

SQLPerformance.com – same great content, new skin!

Aaron Bertrand (@AaronBertrand) provides some details about the new look for SQLPerformance.com and some of the drivers behind the change.

Paul White : Performance Tuning the Whole Query Plan

Paul White (@SQL_Kiwi) demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual operators.

Paul White : Avoiding Sorts with Merge Join Concatenation

Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.

Glenn Berry : Database Server Hardware Trends

Glenn Berry (@GlennAlanBerry) of SQLskills continues on database server hardware trends; today he previews some new processors that may save you some money on SQL Server 2014.

Paul White : Rewriting Queries to Improve Performance

Paul White (@SQL_Kiwi) looks at a couple of cases where – even though T-SQL is supposed to be a declarative language, and any query that uses the same logic and same semantics should ultimately lead to the same plan and comparable performance – rewriting queries can change the plan in dramatic ways.

Erin Stellato : Considerations Around Column Order in Indexes and Sorts

Erin Stellato (@erinstellato) of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.

Aaron Bertrand : Grouped Concatenation : Ordering & Removing Duplicates

Aaron Bertrand (@AaronBertrand) takes a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.

Glenn Berry : Recommended Intel Processors for SQL Server 2014 Workloads

Glenn Berry (@GlennAlanBerry) of SQLskills continues his series on hardware selection, outlining his recommended processors from Intel for your SQL Server 2014 workloads.

Aaron Bertrand : Grouped Concatenation in SQL Server

Aaron Bertrand (@AaronBertrand) shows the safest and most efficient ways to perform grouped concatenation in SQL Server.

Paul White : The 2008 R2 Bug Fix That Breaks RCSI

Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.

Erin Stellato : Should new index columns be in the key, or included?

Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing the key or the INCLUDE list – with interesting results.

Paul White : A Subquery Cardinality Estimation Bug

Paul White (@SQL_Kiwi) uses several examples to describe a bug in cardinality estimation that can be quite difficult to spot if you don't know where to look.

Paul White : The SNAPSHOT Isolation Level

Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with SNAPSHOT.