A while back, I wrote a bunch of posts about things I’d like to see vNext take care of. In this post, since it’s Friday and I don’t wanna do anything, will…
Read the post: Things SQL Server vNext Should Address: How Did I Do?
AI Training for Database Teams and SQL Server Performance Tuning
A while back, I wrote a bunch of posts about things I’d like to see vNext take care of. In this post, since it’s Friday and I don’t wanna do anything, will…
Read the post: Things SQL Server vNext Should Address: How Did I Do?
This setting doesn’t get enough credit for all the good it does. Part of me thinks it should be the default for new SQL Server installs, if the amount of…
Read the post: Things SQL Server vNext Should Address: Add Lock Pages In Memory To Setup Options
Unless you’re running a data warehouse, I can’t think of a good reason to leave this at the default (5) for most any workload.
In 2016, we got the STRING_SPLIT function. That was nice, because prior implementations had a lot of problems
Read the post: Changes Coming To SQL Server’s STRING_SPLIT Function: Optional Ordinal Position
This is my 50th blog post! I’m going to do something a bit special.
One tricky thing about working with dynamic SQL is that it’s rather unaccountable. You have a stored procedure, you build up a string, you execute it, and…
Read the post: Things SQL Server vNext Should Address: Make Dynamic SQL Easily Traceable
The more I work with Standard Edition, the more frustrated I get, and the more I have to tell people about the cost difference between it and Enterprise…
Read the post: Things SQL Server vNext Should Address: Unify Paid Editions
Intelligent Query Processing (IQP) is quite a neat set of features. It allows the SQL Server Engine some flexibility in the plans that get used and…
Read the post: Things SQL Server vNext Should Address: Adaptive DOP
How you do date math in a where clause matters, because wrapping a column in any sort of expression can really hurt your query performance.
Read the post: Things SQL Server vNext Should Address: Making Date Math SARGable
While helping a client out with weird performance issues, we isolated part of the code that was producing a whole bunch of bad plans.
Read the post: Local Variables Get Bad Cardinality Estimates In Cursors In SQL Server, Too
I’ve had to help people with this a few times recently, and it’s always a mess. If you’re lucky, you can use a technique like Andy’s to do it, but even…
Read the post: Things SQL Server vNext Should Address: Going From INT To BIGINT
This issue is one that could be linked to other times when the optimizer defers certain portions of optimization to later stages.
Read the post: Things SQL Server vNext Should Address: Optional Parameters
Lookups are interesting. On the one hand, I think the optimizer should be less biased against them, and on the other hand they can cause a lot of issues.
Read the post: Things SQL Server vNext Should Address: Lookup Placement
People still tell me things like “I only put 100 rows in table variables”, and think that’s the only consideration for their use.
Read the post: Things SQL Server vNext Should Address: Table Variable Modification Performance
I know what you’re thinking: this is another post that asks for a hint to materialize CTEs.
Read the post: Things SQL Server vNext Should Address: Common Table Expression Materialization
I sat down to write this blog post, and I got distracted. I got distracted for two hours.
Read the post: Things SQL Server vNext Should Address: Handling Disjunctive Predicates
I deal with blocking problems all the time. All the damn time. Deadlocks, too.
Read the post: Things SQL Server vNext Should Address: Default Isolation Level
There are two angles to this. One is that spools are just crappy temp tables. The mechanism used for loading data, especially into Eager Spools, is…
Read the post: Things SQL Server vNext Should Address: Spools
Of course, I’d love if everyone lived in the same ivory tower as me and always wrote perfect queries with clear predicates that the optimizer understands…
Read the post: Things SQL Server vNext Should Address: ISNULL SARGability
In my session on using dynamic SQL to defeat parameter sniffing, I walk through how we can use what we know statistically about data to execute slightly…
Read the post: Things SQL Server vNext Should Address: Parameter Sniffing
I’ve written at length about what local variables do to queries, so I’m not going to go into it again here.
Read the post: Things SQL Server vNext Should Address: Local Variable Estimates
Copyright © 2019-2026 Darling Data