Memory Grants part 6: Memory used in aggregate functions (Min/Max/etc)
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
533 reads
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
533 reads
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
976 reads
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,628 reads
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
622 reads
This is not a technical post! Just wanted to say that I set up a public email address for this...
2019-01-19
130 reads
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
749 reads
I first came across the value for RetrievedFromCache when I was reading a confusing execution plan. At first, I thought...
2019-01-11
485 reads
An example of how I use the query hash
I wrote a blog on what the query hash is, right here....
2019-01-10
4,116 reads
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
110 reads
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
65 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I have a column that contains comma separated values. I'm trying to figure out...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers