Have you ever been in the situation that an application performed well yesterday and - suddenly
- you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance!

This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!

- Why performance degradation in spite of maintenance jobs?
- just one more row in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part  bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?

See the problems in demos and learn how to handle it for a better performance!
Presented by Uwe Ricken at SQLBits XIV
MP4 Video HD 576 MB