How to Understand the SSMS Execution Plan

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ส.ค. 2024
  • 📝 Learn and understand the SQL Server Execution Plan: databasestar.com/sqlserverpla...
    🎓 Learn how to improve the performance of your SQL: databasestar.mykajabi.com/get...
    If you work with SQL Server you'll eventually come across a query that runs slowly.
    Then you'll want to know how to make it faster.
    The first step to do this is to learn what the database is doing with the query.
    In this video, you'll learn what an execution plan is, how to display it, and what to look for - all using an example SQL query.
    ⏱ TIMESTAMPS:
    00:00 - Our sample query
    01:10 - Reading the execution plan
    05:25 - Focus areas
    🔗 VIDEO LINKS:
    Queries used in this video: github.com/bbrumm/databasesta...
    Get
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 7

  • @AlexanderWeurding
    @AlexanderWeurding 4 หลายเดือนก่อน

    Thanks for sharing! :)

    • @AlexanderWeurding
      @AlexanderWeurding 4 หลายเดือนก่อน

      Looking forward to in depth :) and the use of dta :)

    • @DatabaseStar
      @DatabaseStar  4 หลายเดือนก่อน

      My pleasure!

    • @AlexanderWeurding
      @AlexanderWeurding 4 หลายเดือนก่อน

      @@DatabaseStar O yes you are single :P Try to reply with some content!

  • @Sedhu_17
    @Sedhu_17 4 หลายเดือนก่อน +1

    hey sir i have a doubt regarding authentication in spring boot ,if u know any idea about that ,i request you to help me
    i have an error like : PreparedStatementCallback; bad SQL grammar [SELECT username, password, enabled FROM site_user WHERE username=?]

    • @DatabaseStar
      @DatabaseStar  4 หลายเดือนก่อน +1

      Thanks for the comment but I don’t know anything about spring boot authentication

    • @Sedhu_17
      @Sedhu_17 4 หลายเดือนก่อน +1

      @@DatabaseStar ok. Thank you