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
144 reads
Arthur's Blog
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
426 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
923 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
44 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
224 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,667 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
52 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers