Daily problems with indexing and its-possible-solution

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!