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 …
Tag: create index in sql server
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 …
Performance Issues With NOT EXISTS Queries
Born Day
I’m going to start this post off sort of like Friday’s post:
…Look, I really like EXISTS and NOT EXISTS. I do. They solve a lot of problems.
This post isn’t a criticism of them at all,
Performance Issues With EXISTS Queries
Dos Puntos
Look, I really like EXISTS and NOT EXISTS. I do. They solve a lot of problems.
This post isn’t a criticism of them at all, nor do I want you to stop using them. I would encourage you …
sp_WhoIsActive Version 12 Is Out!
Get’em Daddy
You know, you love it, you often wondered if it would ever get a new version!
…Someone JUST asked me yesterday if this has been updated recently. Thank you for sharing!
— Erin Stellato (@erinstellato) November 10, 2021