Memory Grants part 3: How much memory can one query get?
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,890 reads
Arthur's Blog
When the query plan hash is deceptive
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
745 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
2,638 reads
It’s always parameter sniffing (part 1?)
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,020 reads
SQL Server Monitoring: What to start measuring
So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...
2019-01-22 (first published: 2019-01-14)
2,624 reads
Execution plans: RetrievedFromCache
I first came across the value for RetrievedFromCache when I was reading a confusing execution plan. At first, I thought...
2019-01-11
382 reads
Why is the query hash so useful?
An example of how I use the query hash
I wrote a blog on what the query hash is, right here....
2019-01-10
2,723 reads
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
107 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
60 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
189 reads
Blogs
Code signing for mere mortals
Well, turns out code signing is pretty complex, so I’m writing this blog post...
Blogging for the Tech Professional at Denver Dev Days
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
Getting AI Written Unit Tests
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
Forums
Software Flexibility (Avoiding the next hack)
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Ask SSC