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."
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.

Paul White : Cardinality Estimation : Combining Density Statistics

Paul White : Cardinality Estimation : Combining Density Statistics

Paul White (@SQL_Kiwi) whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics.

Glenn Berry : Intel Xeon Scalable Processors and SQL Server 2017

Glenn Berry : Intel Xeon Scalable Processors and SQL Server 2017

Glenn Berry of SQLskills walks through the next iteration of Intel Xeon processors, and how they suit SQL Server 2017.

Michael J. Swart : Finding Database Connection Leaks

Michael J. Swart : Finding Database Connection Leaks

Michael Swart (@MJSwart) shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.

Erin Stellato : Testing DML Statements for In-Memory OLTP

Erin Stellato : Testing DML Statements for In-Memory OLTP

Erin Stellato (@erinstellato) takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.

Performance Myths : Oversizing string columns

Performance Myths : Oversizing string columns

Aaron Bertrand (@AaronBertrand) shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.

Tim Radney : Azure Automation Methods

Tim Radney : Azure Automation Methods

Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.

Paul White : Properly Persisted Computed Columns

Paul White : Properly Persisted Computed Columns

Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.

Jonathan Kehayias : Troubleshooting CPU Performance on VMware

Jonathan Kehayias : Troubleshooting CPU Performance on VMware

Jonathan Kehayias of SQLskills discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.

SQLskills Wait Types Library now shows SentryOne data

SQLskills Wait Types Library now shows SentryOne data

Paul Randal (@PaulRandal) explains how the SQLskills Wait Types Library uses anonymous data from SentryOne to indicate whether a wait type is commonly experienced.