After reading this chapter, we should have a better understanding of some aspects that database professionals need to keep in mind to write good queries, and how to identify some inefficiencies that may surface if predicates expressed in queries are not supported by a suitable index design. These are all just a part of the intricacies of writing good, scalable T-SQL code.
In the next chapter, we will cover some easily identifiable T-SQL anti-patterns—some fairly common constructs that, while easy to identify and many times avoided, are still found too many times in critical application code that's required to scale and perform well.
