Darling Data/SQL Server Index Tuning Essentials

  • $49.95

SQL Server Index Tuning Essentials

  • Course
  • 16 Lessons

In this course, I want to teach you about common performance problems you can solve by index tuning SQL Server, and how you can use your query plan and a little brain meat to figure out exactly what you need to do. Most people only worry about an index when it’s fragmented, or when they see a scan instead of a seek. And boy howdy, are they wrong about that! 100 Minutes, Streamed

Contents

Intro
    Joins
      Joins - Demo
        Spools Intro
          Eager Index Spools
            Eager Index Spools - Demo
              Table Spools
                Table Spools - Demo
                  Blocking
                    Blocking - Demo
                      Memory Grants
                        Memory Grants - Demo
                          Threads
                            Threads - Demo
                              Recap
                                Query Tuning WIth Indexes PDF And Demos.zip
                                • 5.44 MB