Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post shows how some assistance from the community helped him isolate and solve the issues.
Learn the subtle ways that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.
Get even more detail about what happens to metadata when you use the schema transfer technique behind the scenes move data and database objects.
So what do you think? What SQL Server performance issues would you like to read about?