Mom I Did It
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 round those up and …
Category: vNext
Things SQL Server vNext Should Address: Add Lock Pages In Memory To Setup Options
Consideration
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 memory in the server is over a certain number, …
Things SQL Server vNext Should Address: Add Cost Threshold For Parallelism To Setup Options
Cracky
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.
Look at any SQL Server setup checklist not written by SharePoint admins, and you’ll see …
Changes Coming To SQL Server’s STRING_SPLIT Function: Optional Ordinal Position
Blueprint
In 2016, we got the STRING_SPLIT function. That was nice, because prior implementations had a lot of problems
But out of the gate, everyone looked at what we got and couldn’t figure why this would drop without a column …
What’s in your SQL Server error log?
This is my 50th blog post! I’m going to do something a bit special.
The Error Log
I’ve found the SQL Server error log to be slightly underrated as a source of useful information for how your SQL Server instance …
Things SQL Server vNext Should Address: Make Dynamic SQL Easily Traceable
An Attempt
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 no one wants to claim responsibility.
Like a secret agent, or …
Things SQL Server vNext Should Address: Unify Paid Editions
Cloudy With A Chance
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 Edition, the more people start asking me about …
Things SQL Server vNext Should Address: Adaptive DOP
Speed Demon
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 re-used.
One in-flight example of IQP is the Adaptive Join, …
Things SQL Server vNext Should Address: Making Date Math SARGable
Whiffle Ball
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.
The thing is that most rewrites are pretty simple, as long as …
Local Variables Get Bad Cardinality Estimates In Cursors In SQL Server, Too
Work Off
While helping a client out with weird performance issues, we isolated part of the code that was producing a whole bunch of bad plans.
At the intersection of bad ideas, there was a cursor looping over a table …