Parameter Sniffing, Predicate Selectivity, And Index Key Column Order In SQL Server

Ғылым және технология

If you like what you see here, you'll love my advanced performance tuning training:
training.erikdarling.com/?cou...

Пікірлер: 13

  • @holidasa
    @holidasa13 күн бұрын

    Well, Mr. Erik Darling, I am very happy to see that you survived your last video’s jump out the window. I hope it’s only a couple of feet (less than a meter) from the ground because “this” is the sort of SQL Server content that I think is fascinating! Your content is very inspiring and always gets me thinking.

  • @ErikDarlingData

    @ErikDarlingData

    12 күн бұрын

    Aw, thank you! I'm glad you find it compelling.

  • @douglascoats7081
    @douglascoats708114 күн бұрын

    idk why youtube was set to 2x speed by default but listening to the chipmunk version of you was entertaining lol

  • @ErikDarlingData

    @ErikDarlingData

    14 күн бұрын

    Wrap It Up Mode™️

  • @mortezasafaee6981
    @mortezasafaee698114 күн бұрын

    I wish you achieve everything you want in your career path thanks youre good man erik 17:44

  • @ErikDarlingData

    @ErikDarlingData

    14 күн бұрын

    Someday I will open a bar on the beach on Bora Bora!

  • @FlaggedStar
    @FlaggedStar14 күн бұрын

    People often say that selectivity isn't the first thing you should look for when ordering index key columns, but they rarely say what the first thing should be.

  • @ErikDarlingData

    @ErikDarlingData

    14 күн бұрын

    The thing that makes the query fastest.

  • @TorgeirFredriksen
    @TorgeirFredriksen13 күн бұрын

    What is the mystery behind "AND 1 = (SELECT 1)"?

  • @ErikDarlingData

    @ErikDarlingData

    12 күн бұрын

    If you had typed that into a search engine instead of the comment box, you would have come across my New York Times best selling blog post, What’s The Point of 1 = (SELECT 1) In SQL Server Queries?: erikdarling.com/whats-the-point-of-1-select-1/

  • @TorgeirFredriksen

    @TorgeirFredriksen

    12 күн бұрын

    @@ErikDarlingData Haha, sorry bout that and thanks for the clarification. I guess it's not the first time you answered this question. A nice trick to prevent trivial plan.

  • @ErikDarlingData

    @ErikDarlingData

    12 күн бұрын

    It is funny you asked, because I was going to record a video version of this post today.

  • @TorgeirFredriksen

    @TorgeirFredriksen

    12 күн бұрын

    @@ErikDarlingData Looking forward to it!

Келесі