Some Stack Exchange Questions I’ve Answered Recently

Good Citizen

---

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!

Going Further

---

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.