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 Reduce CPU of Large Analytic Queries Without Changing Code Microsoft introduced several features called Intelligent Query Processing for SQL Server in 2017 and 2019 that can improve performance without... 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 What are Inline Indexes? New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features... 26 February 2019 13 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming The Performance of Window Aggregates Revisited with SQL Server 2019 T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations... 11 February 2019 11 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 and In-Memory OLTP Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the... 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 T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless... 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
