Query memory grants part 2: Varchars and sorting
Why the heck did we make all our columns varchar? That’s a hypothetical question, please.
But now we have to pay...
2019-01-09
150 reads
Basic PowerShell: Get-Member
Disclaimer: I’m still learning PowerShell. I’ve been using it more lately and I want to talk about it more. I’ll...
2019-01-08
475 reads
Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
961 reads
One tip for presenting: have a conversation
I like public speaking, but I haven’t always liked it. It started when I read Dale Carnegie’s book on public...
2019-01-05
51 reads
Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
239 reads
Query Store max size limit is not a hard limit
If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an...
2019-01-03
1,696 reads
Make sure your nonclustered indexes are enabled
I know this post might sound obvious. This is a very rare problem. But this actually happened to me, and...
2019-01-02
64 reads
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