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.
--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) -
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) -
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) -
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) -
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) -
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) - 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) -
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