Darling Data/Advanced Query Tuning Part 1

  • $99.95

Advanced Query Tuning Part 1

  • Course
  • 34 Lessons

Everything is on the table here. These are the things a DBA must know to fix the problems everyone else thinks are too hard to solve. You'll learn innovative techniques to solve problems no matter what your situation is. This video will cover parameter sniffing, lookups, sorts, functions, optional parameters, paging, and how to tune those gigantic queries that bring your server crashing down. 4.5 Hours, Streamed

Contents

Advanced Query Tuning Part 1
    Query Tuning WIth Rewrites PDF And Demos.zip
    • 24.5 MB

    A Blueprint For Tuning

    Intro
      Information vs. Relational
        Clear Predicates
          Adequate Indexes
            Manageable Logic
              Recap

                Blueprint - Parameter Sniffing

                If-Branching Does Not Work
                  If-Branching Does Not Work - Demo
                    Parameter Sniffing Intro
                      Optional Recompile
                        Optional Recompile - Demo
                          Optimize For You
                            Optimize For You - Demo
                              Temp Table
                                Temp Table - Demo
                                  Recap

                                    Blueprint - Lookups

                                    Intro
                                      Predicate Lookups
                                        Predicate Lookups - Demo
                                          Fixing Lookups With TOP
                                            Fixing Lookups With TOP - Demo
                                              Lookups and Relational CTEs
                                                Lookups and Relational CTEs - Demo
                                                  Recap

                                                    Blueprint - Sorts

                                                    Intro
                                                      Indexes
                                                        Indexes - Demo
                                                          Missing Indexes Demo
                                                            Indexes Are Not The Problem
                                                              Indexes Are Not The Problem - Demo 1
                                                                Indexes Are Not The Problem - Demo 2
                                                                  Recap