How to Think Like the Engine Part 2

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 9

  • @Dmitriy.0
    @Dmitriy.0 2 роки тому +15

    Being roasted by Brent in one of his live classes is the highlight of my week.

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  2 роки тому +1

      Always good to see you in the audience, sir!

    • @harisimer
      @harisimer Рік тому +2

      its actually the only reason why I do not consider paying for the courses. there are coaches that have a better insight into their students instead of thinking they are stupid. he explains it pretty good, but his attitude makes it hard to bother listening.

    • @HHdouHH
      @HHdouHH Рік тому

      @@harisimer I love this kind of instruction. You can remember better your mistake with a funny roast than a 'tuddeliwuddeli poor dba'. And like Brent said, you choose this job. When you grilled your companies sql server, there wouldnt be tuddelies... only finger pointing brents :)

    • @harisimer
      @harisimer Рік тому

      @@HHdouHH I dont know what you mean, it is not a specific case that someone would be ignored for having poor behavior, its generally like this

  • @robertwest4596
    @robertwest4596 2 роки тому +1

    Why do you include the ID column in the non-clustered index? ID is already part of the non-clustered index by default. All non-clustered indexes have the clustered index columns in them, and you don't need to specify them in any non-clustered index.

  • @jjno
    @jjno Рік тому

    i know youre covering sql server, but are your videos' ideas also applicable to other dbs like oracle? are the ideas like index performance the same for other dbs?

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  Рік тому

      Unfortunately, I have no way to know - I don't work with other databases.