I'm looking for something short here. A scenario or two and how you can determine what is being used, and potential downfalls of the technique (counters reset). The idea is to focus here.

If you're like to do a second piece (or just write something), on more tuning indexes based on queries or other items, then that's fine as well.