Options Ahoy
There are lots of great options out there for figuring out what’s happening on a server. If you’re the kind of person still running sp_who, or sp_who2, or sp_who8045, it’s time to stop.
You’ve got much better options, …
Category: Memory Grants
SQL Server 2019 Memory Grants Are Higher
Because I Got
…
All The Problems With Select *
This was originally posted by me as an answer here. I’m re-posting it locally for posterity.
The two reasons that I find the most compelling not to use SELECT * in SQL Server are
- Memory Grants
- Index usage
Memory
…Does Parallelism Change Memory Grants?
This was originally posted as an answer by me here, I’m re-posting it locally for posterity
Sup?
For SQL Server queries that require additional memory, grants are derived for serial plans. If a parallel plan is explored and chosen, …
Bad Guesses and Bad Choices
Let’s Run A Cruddy Query
We’ve got no supporting indexes right now. That’s fine.
The optimizer is used to not having helpful indexes. It can figure things out.
SELECT p.*
FROM dbo.Posts AS p
JOIN dbo.Votes AS v
ON p.Id … Distinct Rows, And The Columns You Choose
Footnote
I have two queries. They return the same number of rows.
The only difference is one column in the select list.
This query has the Id column, which is the primary key and clustered index of the Posts table.…
Memory Grants For SQL Variant
Great Question, You
During my (sold out, baby!) Madison precon, one attendee asked a great question while we were talking about memory grants.
Turns out, if you use the SQL Variant datatype, the memory grants function a lot like they …