Playing The Odds
Assuming that life carries on as usual for a couple more weeks, I’ll have been a consultant here for three years.
In that time, I’ve had some really interesting conversations with people, mostly about why things are the way they are on their servers.
My favorite response is “isn’t that the default?”, because it’s never the default.
I think that’s called an unforced error.
Here are some of my favorites:
- Nonclustered Primary Keys
- Fill factor < 100
- MAXDOP 1
- Fifteen minute log backups
- Single column indexes
- Indexes including every column
- Database shrink tasks at the end of maintenance plans
- Read uncommitted
- Priority Boost
Thanks for reading!
Brent says: Ooo, yeah, my favorite: “SQL Server has built-in emails that alert me when there’s a problem, right?”