WHAT DO YOU MEAN YOU’RE NOT ON SQL SERVER 2019 YET.
Look, whenever you make changes to the optimizer, you’re gonna hit some regressions.
And it’s not just upgrading versions, either. You can have …
If you haven’t heard by now, Table Variables have some ✌features✌ that can cause performance issues pretty generally in SQL Server.
There was one thing that I didn’t talk about earlier in the week.
You see, there’s a mystery plan.
It only shows up once in a while, like Planet X. And when it does, we get bombarded …
Let’s talk about some common hints that people use to fix parameter sniffing:
We’ve got a problem, Sam Houston. We’ve got a problem with a query that has some strange issues.
It’s not parameter sniffing, but it sure could feel like it.
When I first wrote this demo, I called it
Because , you know, it’s really terrible.
CREATE OR ALTER PROCEDURE dbo.VoteSniffing( @VoteTypeId INT ) AS SET XACT_ABORT, NOCOUNT ON; BEGIN SELECT ISNULL(v.UserId, 0) AS…
I’ve always had trouble standing still on SQL Server versions, but most companies don’t. Hardly anyone I talk to is on SQL Server 2017, though these days SQL Server 2016 seems more common than SQL Server 2012, …
It’s that time of the release cycle again! Microsoft has published the stuff that different editions of SQL Server 2019 will do or not do.
First up, I don’t disagree with any of the feature choices. They’re fine.…