SQL Server Performance Tuning and Optimization

SQW11 Improve Your Database Performance in Seven Simple Steps


4:00pm - 5:15pm

Level: Introductory to Intermediate

Hugo Kornelis

Freelance Database Developer/Consultant

You wrote the code, you tested it, it works, and it's fast. So you deploy. And then those pesky users insist on entering not hundreds, not thousands, but millions of rows – and suddenly, you have performance problems.

What to do? Blaming SQL Server is a good start, but won't solve the problems. You can of course hire a database consultant to make all your performance problems (and all your money) disappear - but why not first take a look yourself?

This session will show you seven simple things, that might alleviate most of your database related performance problems. Use these tricks at your workplace, and you can be the hero of the department!

You will learn:

  • Understand why set-based queries are faster than cursor-based code
  • Understand why indexes are needed and how they can be optimally used
  • Understand good and bad parameter sniffing and how to work around the latter