Faster SQL Servers Without Changing Queries or Indexes with Brent Ozar

Your users are complaining that SQL Server is slow, but you can't fix the code or the database, and the company isn't throwing hardware at the problem yet. What can you do? Use specific configuration changes to reduce the hardware required to run queries.We'll discuss blocking and other scenarios where SQL Server's configuration switches make all the difference. Code and indexes may still need work, but you'll have a few options to help in the meantime.