Following a Structure When Performance Tuning, Part 3: Common Performance Problems
This is part three of the blog series on following a structure when performance tuning. From the previous posts (part
September 10, 2024
Author: Rich Benner
Following a Structure When Performance Tuning, Part 2: Identifying Problem Statements
If you’ve followed along with the previous blog, you’ll now have a way to re-run and test your query as
July 31, 2024
Following a Structure When Performance Tuning, Part 1
So, you have a database or block of code. You’ve been told to “make it fast” but you’re not sure
July 15, 2024
Contained Availability Groups in SQL Server 2022
SQL Server 2022 brought us Contained Availability Groups. This post outlines the new features and some of the pitfalls that we have seen.
May 22, 2024
SQL Server Antipatterns: Common Mistakes with SQL Code
In today’s tech-saturated world, we expect developers to have a broad range of skills and programming languages at their disposal,
February 21, 2024
SQL Server on a Diet: Improve the health of your database
We often see databases that are simply larger than they need to be. This is usually attributable to technical debt
December 14, 2023
Blindsided by Database Corruption
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t
September 20, 2023
Parallelism in SQL Server
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
July 12, 2023
How To: Clear Backup History
SQL Server should clear up system tables, but doesn’t. And that’s a problem. This post shows you how to clear backup history.
June 13, 2023
SQL Server and the (not so mysterious) Mystery of Three-Valued Logic
SQL Server’s three-valued logic is a concept that extends the traditional two-valued logic to include a third value, known as NULL. Three-valued logic is used to handle cases where the value of a column in a database table is unknown or not applicable. Get to grips with this complex idea.
April 21, 2023