SentryOne Team Blog (blogs.sentryone.com)

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 : Minimal Logging with INSERT…SELECT into Empty Clustered Tables

Paul White : Minimal Logging with INSERT…SELECT into Empty Clustered Tables

Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – subqueries

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – subqueries

Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.

Paul White : Minimal Logging with INSERT…SELECT into Heap Tables

Paul White : Minimal Logging with INSERT…SELECT into Heap Tables

Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.

Sending SentryOne Data to the Azure SQL Database DTU Calculator

Sending SentryOne Data to the Azure SQL Database DTU Calculator

Guest author Dustin Dorsey shows how to prepare for a migration to Azure SQL Database by sending SentryOne monitoring data to the DTU calculator.

Paul White : Grouped Aggregate Pushdown

Paul White : Grouped Aggregate Pushdown

Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.

Itzik Ben-Gan : Row Pattern Recognition in SQL

Itzik Ben-Gan : Row Pattern Recognition in SQL

Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.

Glenn Berry : AMD EPYC Processors in Azure Virtual Machines

Glenn Berry : AMD EPYC Processors in Azure Virtual Machines

Glenn Berry talks about the AMD EPYC CPUs now found in Azure Virtual Machines (in some regions) and their usage in balanced SQL Server workloads.

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.

Filtered Indexes and INCLUDEd Columns

Filtered Indexes and INCLUDEd Columns

Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.

Tim Radney : Azure SQL Database Performance Tuning Options

Tim Radney : Azure SQL Database Performance Tuning Options

Tim Radney explains some of the nuances of performance tuning your workloads in Azure SQL Database and Azure SQL Database Managed Instance.

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.

Erin Stellato : Use XEvent Profiler to capture queries in SQL Server

Erin Stellato : Use XEvent Profiler to capture queries in SQL Server

Erin Stellato walks through a quick and simple way to use Extended Events and the new XEvent Profiler to review queries on your system.

Charlotte SQL Server User Group : Fix Slow Queries. Fast.

Charlotte SQL Server User Group : Fix Slow Queries. Fast.

Download the slide deck from Aaron Bertrand's latest presentation, "Fix Slow Queries. Fast."

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.