Query Store, Plan Forcing and Table Variables
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
The...
2019-05-06
Database Performance
SQL Server Monitoring Week – SQL Plan Warnings
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database...
2019-04-26
Why Plan Cache Scripts Can Be Misleading
A Long Way From Home Most scripts (even ones I’ve worked on!) that look at the plan cache, have had…
2019-04-26
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
The post Yes, pulling just the data...
2019-04-24
When READPAST Doesn’t Read Past
Oh, Bother Sometimes, you only wanna work on one thing. Other times, you only wanna work on something if it’s…
2019-04-24
Slightly Less Not SARGable
Date Debate Searching dates is a common enough task. There are, of course, good and bad ways to do this.…
2019-04-22
Which Database is Causing the Problem?
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first? Here are a few ways you can pick...
2019-04-17
Index scans aren’t always bad, and index seeks aren’t always great.
Somewhere along the way in your career, you were told that: Index seeks are quick, lightweight operations Table scans are ugly, slow operations And ever since, you’ve kept an...
2019-04-16
Have Your Batch Updates Become Unmanageable?
Look, I’m telling you this as a friend. Seriously, it’s time to let go of your batch updates. It’s not a...
2019-04-16
When Inline UDFs are Slower
Brent Ozar has been digging deep into new functionality in SQL Server 2019: In the Froid white paper, Microsoft talked about how they were working on fixing the function...
2019-04-15
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers