I recently self-answered this question because I noticed a lot of questions that seemed to be about parameter sniffing, without users knowing the term for it, or how to provide information that would help us help them.
Since it seemed like a pretty popular Q&A, I'd be open to doing more (or letting other folks do them if they feel like it) to help.
Before I do that, I'd like to solicit community ideas for what helpful Q&A would look like.
What I'd like to know:
- What other common scenarios would be good to document
- Would you like to do them?
- Query performance
- Query rewrites
- Index tuning
The reason I'm posting this here is because I don't want anyone to feel like I'm spamming the board with useless Q&A. The information in the one on Parameter Sniffing has good general information about what information to provide and how to provide it, so more might be overlapping overkill.
There's some stuff like security, HA/DR, audits, Change Tracking, CDC, and encryption that I'm not well versed enough with to do.
There's also the crazy possibility that someone may want to do something similar for a platform other than SQL Server. I couldn't possibly do that justice, so that's totally open.