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."
Paul White : Row Goals Part 2 : Semi Joins

Paul White : Row Goals Part 2 : Semi Joins

Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.

Erin Stellato : Automatic Plan Correction in SQL Server

Erin Stellato : Automatic Plan Correction in SQL Server

Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.

Paul White : Setting and Identifying Row Goals in Execution Plans

Paul White : Setting and Identifying Row Goals in Execution Plans

Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.

Q & A from our Parameter Sniffing webinar series

Q & A from our Parameter Sniffing webinar series

Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.

Bridging the Azure gap : Managed Instances

Bridging the Azure gap : Managed Instances

Tim Radney gives an overview of Managed Instances, and explains how they bridge the gap between on-premises SQL Server and Azure SQL Database.

Glenn Berry : Hidden Improvements in SQL Server 2012 / 2014

Glenn Berry : Hidden Improvements in SQL Server 2012 / 2014

Glenn Berry explains several manageability and performance improvements relevant to those of you running SQL Server 2012 and SQL Server 2014.

Jonathan Kehayias : Impact of Fragmentation on Execution Plans

Jonathan Kehayias : Impact of Fragmentation on Execution Plans

Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.

Tim Radney : New Azure SQL Database Standard Tier Sizes

Tim Radney : New Azure SQL Database Standard Tier Sizes

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.

Erin Stellato : Wait Statistics and Query Store

Erin Stellato : Wait Statistics and Query Store

Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database.

Glenn Berry : Azure Virtual Machine Developments

Glenn Berry : Azure Virtual Machine Developments

Glenn Berry explains the importance of hardware choices for SQL Server running on your own hardware vs. Azure Virtual Machines.

Erin Stellato : UPDATEs to Statistics

Erin Stellato : UPDATEs to Statistics

Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017.

Rob Farley : Because you need to know PowerShell

Rob Farley : Because you need to know PowerShell

Rob Farley (@rob_farley) gives a rather thorough crash course on PowerShell for this month's installment of T-SQL Tuesday.

Paul White : Trigram Wildcard Search in SQL Server

Paul White : Trigram Wildcard Search in SQL Server

Paul White discusses the pros and cons of maintaining three-character substrings (trigrams) to speed up wildcard searches. Continue reading…

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.

Andy Mallon : Multi-Statement TVFs in Dynamics CRM

Andy Mallon : Multi-Statement TVFs in Dynamics CRM

Andy Mallon (@AMtwo) walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.