Level: Introductory to Intermediate
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