Inconsistent Error Handling By SQL Server

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2024

Комментарии • 12

  • @FlaggedStar
    @FlaggedStar Месяц назад +2

    I always insist that every DBA must read Sommarskog's three-part series on this.

    • @recce8619
      @recce8619 Месяц назад +2

      Erland's the man. Error handling and Dynamic SQL are classic posts
      Love his web site, it's so 80s.

    • @ErikDarlingData
      @ErikDarlingData  Месяц назад

      Hahaha, do you QUIZ THEM afterwards?

    • @FlaggedStar
      @FlaggedStar Месяц назад +1

      @@ErikDarlingData I should put it in the job interview!

    • @ErikDarlingData
      @ErikDarlingData  Месяц назад

      It’s the only way to be safe, yeah.

  • @mjswart73
    @mjswart73 Месяц назад +1

    "Extra Committed" would be a great name for your podcast

    • @ErikDarlingData
      @ErikDarlingData  Месяц назад

      Hahaha, only if we co-host 😃

    • @mattcargile
      @mattcargile Месяц назад

      Speaking of that where is you and Joe, Erik

  • @plancktime9750
    @plancktime9750 Месяц назад +2

    How is this not a bug?

  • @clerincg
    @clerincg Месяц назад +1

    I'll never turn XACT_ABORT off, ever! Can you tell me if the default is on?

    • @ErikDarlingData
      @ErikDarlingData  Месяц назад +1

      No, the default is off (except in triggers).