Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
Tag: Query Plan
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, …
Happy Thanksgiving From Darling Data
Why Are You Here?
In the fine tradition of a turkey being pardoned from becoming the centerpiece of a meal, I’m pardoning you from having to read a blog post about SQL Server.
Wherever you are, whoever you are, have …
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 …
Creating SQL Server Indexes: Stored Options vs. Creation Options
No Lies
When you create an index, there are a lot of options. Recently while working with nice people who pay me, I’ve gotten the same question a few times.
I like to hand off index change scripts to people …
Of Temporary Tables And Plan Cache Pollution
I Love #Temp Tables
I solve a lot of problems with #temp tables, indeed I do. And I hate people who are reflexively anti-#temp table.
If you’re into jokes (I’m definitely not into jokes; SQL is serious business), you …
EAV Can Be Great, But It Depends On How You Query It
Valued
EAV styled tables can be excellent for certain data design patterns, particularly ones with a variable number of entries.
Some examples of when I recommend it are when users are allowed to specify multiple things, like:
- Phone numbers
Signs You Need More Memory In Your SQL Server
Guessotron
Most of these signs have to do with wait stats. One could venture out and say that if you have way less memory than data, you need more memory, but… If the server is sitting around bored, who cares?…
Signs You Need SQL Server Enterprise Edition
But Postgres Is So Much Cheaper
There’s a lot of cool stuff in Enterprise Edition of SQL Server, which is probably why it costs $7000 a core.
When’s the last the price went up, though? Hm?
Real Availability Groups
HA …
Signs You Need Batch Mode For Your SQL Server Queries
My Name Is
I speak with a lot of DBAs and developers who have either heard nothing about column store and batch mode, or they’ve only heard the bare minimum and aren’t sure where it can help them.
Here’s a …