SQL is by far the most common language for processing data, but despite being so pervasive and powerful, it’s really easy to use badly. This sessions highlights some of the common mistakes, anti-patterns and traps developers fall into when using SQL badly, as well as how to turn those sins into a wins.
I cover the following:
- Context : Understand what you are trying to achieve before you launch into it
- Design : I use an example of the One True Lookup Table anti-pattern to discuss the impact of bad design
- Retrieving too much data
- Views
- Bind variables
- Excessive use of sub-selects
- Functions in SQL