When you run a query, SQL Server guesses how much memory you're going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you're about to do, and doesn't grant you enough memory. Say you're working with…
Psst - you're probably not supposed to see this yet, but look what @WalkingCat found:
https://x.com/h0x0d/status/1042979511074086913
TEASE
Who Let The Docs Out?
If you head over to Microsoft's GitHub repo, you can peruse around for stuff updated recently.
In no particular order: Database Level Option for Storing Wait Stats - just like we can store query plan history in Query Store, it'd be awesome to get performance history over time. Give more info on the "String or Binary Data Would be Truncated" error - tell us which column, and what row tried to…
Scalar functions and multi-statement table-valued functions are notorious performance killers. They hide in execution plans, their cost is under-estimated, the row estimates are way off, they cause queries to go single-threaded, I could go on and on.
Microsoft is bringing a fix in SQL Server 2019, and thanks to a newly published paper, we know more about how they're doing it. Folks from Microsoft and the Gray Systems Lab wrote Froid: Optimization of Imperative Programs in a Relational Database (17-page PDF, and slightly easier-to-digest 12-page PDF).
When will Microsoft officially release SQL Server 2019 for download? The dust is just barely starting to settle on the 2017 box, so it's time to guess the next one. Leave one – and only one – comment here in YYYY/MM/DD format with your release date guess. If you leave multiple comments, only the first/earliest…
I happened to be in Seattle this week after finishing up an Alaska cruise, and I had the chance to sit down with some of the PMs responsible for upcoming SQL Server features. It turns out they're already deep in development with some truly revolutionary capabilities.
Now, I probably shouldn't be sharing these with you, dear reader, but I bet you're going to be as excited as I am, so here goes: SQL Server 2019's upcoming feature list:
