When I have spare time, I answer questions over at the Database Administrators Stack Exchange site.
Here are some recent ones that I’ve found interesting:
- Cannot run query to get deadlock graph in a timely fashion
- Query plan not reused for identical queries sp_executesql vs adhoc
- Query store – bumping up max_storage_size_mb works for a short while then goes back to 250?
- Slow CTE update query
- AppDomain 2 SSISDB is Marked for Unload due to Memory Pressure
If you like this style of Q&A, I’d highly suggest signing up and contributing. It’s a great way to share and learn.
Thanks for reading!
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.