An overview of some concepts that are important to understand when examining query plans or troubleshooting slow queries.

This post lists some options that you might consider if you need to do an indexed lookup of values that are longer than SQL's 900 bytes limit on index keys.