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

Paul White : UNION ALL Optimization

Paul White : UNION ALL Optimization

Paul White (@SQL_Kiwi) digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.

Paul White : SQL Server Temporary Object Caching

Paul White : SQL Server Temporary Object Caching

Paul White (@SQL_Kiwi) describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

Monica Rathbun : I/O Troubleshooting

Monica Rathbun : I/O Troubleshooting

Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

Paul White : Cardinality Estimation for a Predicate on a COUNT Expression

Paul White : Cardinality Estimation for a Predicate on a COUNT Expression

Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.