Performance Fabiano Amorim in Performance Tempdb – Here’s a Problem You Didn’t Know You Had Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration... 21 April 2020 14 min read
T-SQL Programming Greg Larsen in T-SQL Programming SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries SQL Server 2019 Batch Mode on Rowstore reduces CPU usage of large analytic aggregate queries by 20–30% without rewriting any... 25 March 2020 19 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Understanding the NAND Flash Solid State Drive Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this... 11 March 2020 13 min read
Performance Greg Larsen in Performance Get Your Scalar UDFs to Run Faster Without Code Changes Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article,... 10 February 2020 14 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Language of Storage Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.… 22 January 2020 13 min read
Database Administration Forrest McDaniel in Database Administration How Does Accelerated Database Recovery Work? Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for... 26 November 2019 12 min read
T-SQL Programming Monica Rathbun in T-SQL Programming What Are Columnstore Indexes in SQL Server? Explained Learn what columnstore indexes are in SQL Server, how they store data by column instead of row, and why they... 22 July 2019 16 min read
Performance Samir Behara in Performance Designing Highly Scalable Database Architectures While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and... 09 April 2019 13 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Inline Indexes: Add Indexes to Table Variables and UDTTs SQL Server inline indexes let you define clustered, nonclustered, and filtered indexes directly in CREATE TABLE syntax for table variables,... 26 February 2019 13 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore SQL Server 2019 Batch Mode on Rowstore dramatically improves window aggregate performance - running totals, moving averages, and accumulating SUM... 11 February 2019 12 min read
T-SQL Programming Greg Larsen in T-SQL Programming There is a New COUNT in Town Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this... 29 November 2018 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions: Performance, NTILE & Framing Master T-SQL window function performance: understand OVER clause sorting, PARTITION BY, NTILE, framing (ROWS vs RANGE), indexing strategies, and how... 27 June 2018 11 min read
Data Privacy and Protection Hugo Kornelis in Data Privacy and Protection Execution Plans and Data Protection One of the most important tools for query tuning is the ability to view execution plans. They are even portable;... 10 April 2018 23 min read
Performance Uwe Ricken in Performance READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it... 06 March 2018 12 min read
Database Administration Dennes Torres in Database Administration Parameter Sniffing: Fix It with Query Store Diagnose and fix SQL Server parameter sniffing problems using Query Store. Identify bad plan reuse, compare execution plans, and force... 06 June 2017 25 min read
Database Administration Enrico van de Laar in Database Administration Query Store with In-Memory OLTP: What Gets Captured for Memory-Optimized Tables and Natively Compiled Procedures How SQL Server Query Store interacts with In-Memory OLTP features - the statistics available for regular queries against memory-optimized tables... 04 January 2017 11 min read
Performance Robert Sheldon in Performance SQL Server Statistics Basics Distribution statistics are used by SQL Server's Query Optimiser to determine a good execution plan for your SQL query. You... 22 July 2016 17 min read
Kathi Kellenberger FIFO Stock Inventory in T-SQL: The Window Function Approach vs Dave Ballantyne’s Original Set-Based Solution Solving the FIFO (first-in, first-out) stock inventory problem in T-SQL with window functions - Aunt Kathi Kellenberger's approach using SUM()... 16 March 2016 14 min read
Dwain Camps SQL Conditional JOIN: Why It’s Slow & What to Use Instead Learn why conditional JOINs using CASE in the ON clause cause poor SQL Server performance. Compare alternatives: LEFT OUTER JOIN... 07 September 2015 14 min read
Kathi Kellenberger T-SQL Window Functions Speed Phreakery Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to... 27 August 2015 12 min read
