EightKB... I'm presenting! Bring your water-cooled helmet! :D

  • EightKB... I'm presenting!

    If you've not seen this one before, it will totally blow your mind. To summarize, in one of the most heterodixic SQL presentations you're likely to ever see, I destroy the myth of Random GUID fragmentation, show how they can be used to actually prevent fragmentation, and lay waste to what people currently use as "Best Practice" Index Maintenance.

    Bring your water-cooled helmet... you're going to need it.

    https://eightkb.online/

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • It will be good to hear you again. It's been a while for me.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution ๐Ÿ˜€

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Thanks, Johan.ย  It's been a decade since the two of us have had the chance to talk in person.ย  IIRC, the last time was at the PASS Summit of 2011.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Jeff, I am so looking forward to this!

  • Thanks for the feedback, Tom.ย  I love to teach and I really love teaching this one.ย  It's a shame we can't do these in person because I'd love to see people's faces, especially for the final frame in the presentation. ๐Ÿ˜€

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Thoroughly enjoyable, brilliant presentation Jeff.

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    โ€” Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Thanks, David. I really appreciate you taking the time to provide feedback.

    I went overtime because I got comfortable and slowed down.ย  I needed to keep the pace up on that one.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it ๐Ÿ™‚ ).

    Lots of good stuff.

    Now I just have to find IndexDNA ๐Ÿ™‚

    Far away is close at hand in the images of elsewhere.
    Anon.

  • You're welcome. ThankYOU for taking the time to put together such a digestible presentation on something quite advanced. You are a natural trainer. Plus, most PowerPoint Jockeys could also learn from you how to use PowerPoint effectively!

    PS: nice to have a face to put to the name ๐Ÿ˜€

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    โ€” Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Jeff,

    Thank you for a truly great presentation that shatters a lot of long held beliefs. Certainly one's I've held and I'm sure many others.

    -Tom

  • David Burrows wrote:

    I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it ๐Ÿ™‚ ). Lots of good stuff. Now I just have to find IndexDNA ๐Ÿ™‚

    I just sent the folks at 8KB the zip file for the presentation.ย  In not only contains the PPT file but it also contains a PowerPoint Show file for those that don't have PowerPoint installed.ย  It also contains the code and related spreadsheet for sp_IndexDNAโ„ข and the code for a whole lot of the testing that I did that we couldn't get to during the meeting.ย  I don't know when they'll actually do the uploads but I imagine it would only be a few more days.

    Thank all of you for the great feedback!

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • It was a great session, Jeff

    Good to hear you again ๐Ÿ™‚

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution ๐Ÿ˜€

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Tom Uellner wrote:

    Jeff,

    Thank you for a truly great presentation that shatters a lot of long held beliefs. Certainly one's I've held and I'm sure many others.

    -Tom

    Thanks Tom.ย  I really appreciate the feedback on that one especially since I've got close to 600 hours (not a misprint... about 600 hours) into the testing an coding.

    Oddly enough, it all shattered many of my previous beliefs as well when I was doing the testing and the revelations started to hit me during the testing and retesting to make sure I hadn't "invented cold fusion", if you know what I mean.ย  My mind was totally blown and that's the reason I built sp_IndexDNAโ„ข ... I HAD to see what was going on at the page level because I couldn't believe what I was seeing during the repetitive testing.

    I'm really tickled that the revelations also blew your mind.ย  That's exactly what I was looking for.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Johan Bijnens wrote:

    It was a great session, Jeff Good to hear you again ๐Ÿ™‚

    Thanks, Johan.ย  It's a shame we couldn't have a couple of beers together afterwards like we did the last time... a decade ago in Seattle.ย  Lordy... it's been that long.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • indeed, Jeff. Time flies when you're having fun ??

    I hope there will be an occasion in the near future, when we have adapted to cope with covid-vnext.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution ๐Ÿ˜€

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply