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!