Here, we provide additional resources and real-world performance tuning case studies that did not fit the format of a book:

• A case study of tuning partition elimination, dropping execution time from 40 minutes to a few seconds.
• How the misuse of USI caused a tenfold increase in storage space.
• SQL query rewriting switched the execution plan to sliding window inclusion merge join. The execution time dropped from 35 minutes to 25 seconds.
• Templates for TPT import and export scripts.