SQLPerformance.com - SentryOne Team Blog

SQLPerformance.com

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."
Erin Stellato : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

Follow-up #1 on leading wildcard seeks

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

One way to get an index seek for a leading %wildcard

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

Erin Stellato : Compression and its Effects on Performance

Erin Stellato : Compression and its Effects on Performance

Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

Photo credit: rsdio

Rob Farley : Estimated Number of Rows to be Read

Rob Farley : Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

SQL Server v.Next : STRING_AGG Performance, Part 2

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand (@AaronBertrand) starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

SQL Server v.Next : STRING_AGG() performance

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.

Glenn Berry : SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry : SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

Memory Limits in SQL Server 2016 SP1

Memory Limits in SQL Server 2016 SP1

Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato (@erinstellato) discusses the types of performance data needed to help with capacity planning.

A Big Deal : SQL Server 2016 Service Pack 1

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change to SQL Server 2016 in Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

Can comments hamper stored procedure performance?

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.

Tim Radney : Migrating Databases to Azure SQL Database

Tim Radney : Migrating Databases to Azure SQL Database

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.