No matter which platform they use, many SQL developers continue to struggle with concurrency, resource management, space management, and speed. These tips may help:
- Don’t use UPDATE instead of CASE
- Don’t blindly reuse code
- Do pull only the number of columns you need
- Don’t double-dip
- Do know when to use temp tables
- Do pre-stage data
- Do delete and update in batches
