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? Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to... 22 July 2019 15 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 and Performance T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article,... 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 Query Store and Parameterization Problems The query store gives us a novel way of identifying those queries that are causing performance problems when they are... 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 How to Avoid Conditional JOINs in T-SQL Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within... 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
