Performance Aaron Bertrand in Performance Normalize strings to optimize space and searches While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange... 02 October 2023 9 min read
Performance Dennes Torres in Performance SQL Server 2022: Capture SQL Anti-Patterns One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended event allows to... 01 June 2023 6 min read
Performance Edward Pollack in Performance Automating Extended Events data collection It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In... 04 October 2021 18 min read
Performance Fabiano Amorim in Performance SQL Compilations/sec: What This Metric Really Means Why the standard SQL Compilations/sec guideline is misleading for ad hoc workloads. Covers plan cache behavior, auto-parameterization, forced parameterization, and... 29 July 2021 25 min read
Performance Edward Pollack in Performance Collecting SQL Server performance monitor data SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.… 20 July 2021 20 min read
Performance Edward Pollack in Performance SQL Server performance monitor data: Introduction and usage Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some... 29 June 2021 13 min read
Database Administration Robert Sheldon in Database Administration SQL Server performance tuning: Nine best practices SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains... 28 May 2021 14 min read
Performance Edward Pollack in Performance SQL Server plan cache mining – Plan attributes Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance... 26 April 2021 20 min read
Database Administration Monica Rathbun in Database Administration TempDB Growth: Diagnose & Fix SQL Server Issues Fix uncontrolled TempDB growth in SQL Server. Learn to diagnose causes - query spills, version store, temp tables - shrink... 22 March 2021 11 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Monitoring storage metrics Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important... 06 October 2020 15 min read
Performance Edward Pollack in Performance SQL Server Remote Data: Linked Servers, OPENQUERY & ETL Best practices for accessing remote data in SQL Server. Covers linked servers, OPENQUERY vs four-part naming, SSIS packages, OPENROWSET, and... 30 September 2020 23 min read
Performance Robert Sheldon in Performance SQL Server Computed Columns: Persisted vs Indexed Performance Compare SQL Server computed column performance across four configurations: non-persisted, persisted, indexed, and indexed-persisted. Includes execution plans and benchmarks using... 10 September 2020 14 min read
T-SQL Programming Edward Pollack in T-SQL Programming Query Patterns for Columnstore Indexes: Joins & Performance (Part 4) Optimize query patterns against columnstore indexes in SQL Server. Learn segment and rowgroup elimination, dimension table joins, performance pitfalls, and... 01 September 2020 21 min read
Performance Edward Pollack in Performance Columnstore Index Maintenance: Rebuild, Reorganize & Options Guide to columnstore index maintenance in SQL Server. Covers rebuild vs reorganize, rowgroup management, nonclustered columnstore indexes, and memory-optimized columnstore... 21 July 2020 23 min read
T-SQL Programming Edward Pollack in T-SQL Programming Columnstore Index Best Practices: Data Order & Partitioning (Part 2) SQL Server columnstore index best practices: optimize data order for rowgroup elimination, use segment metadata, implement partitioning, and apply archive... 24 June 2020 20 min read
Performance Greg Larsen in Performance Improve Row Count Estimates for Table Variables without Changing Code Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019,... 26 May 2020 12 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 1 The Basics Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of... 21 May 2020 9 min read
T-SQL Programming Edward Pollack in T-SQL Programming Columnstore Index Architecture in SQL Server (Part 1 of 4) Deep dive into columnstore index architecture in SQL Server. Learn how rowgroups, segments, the deltastore, and compression work with hands-on... 21 May 2020 23 min read
Editorials Kathi Kellenberger in Editorials Key Insights from the 2020 State of SQL Server Monitoring Report This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This... 20 May 2020 3 min read
Performance Greg Larsen in Performance Right-Sizing Row Mode Query Memory Requirements When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be... 29 April 2020 16 min read
