Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
One of the most common “false positives” that people see when troubleshooting query plans is that updating statistics “fixes” a problem. In this first session, we'll decipher the ACTUAL problem - caching or statistics?
In this second session, we'll talk about problems that are NOT caching related but in fact, actually statistics problems? More importantly, I'll give you ways to help solve them!