June 15, 2021 at 6:16 pm
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
Change is inevitable... Change for the better is not.
June 16, 2021 at 9:20 am
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
June 16, 2021 at 3:28 pm
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
Change is inevitable... Change for the better is not.
June 22, 2021 at 8:43 pm
Jeff, I am so looking forward to this!
June 22, 2021 at 11:48 pm
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
Change is inevitable... Change for the better is not.
July 28, 2021 at 3:53 pm
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?
July 29, 2021 at 5:33 am
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
Change is inevitable... Change for the better is not.
July 29, 2021 at 8:05 am
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.
July 29, 2021 at 9:50 am
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?
July 29, 2021 at 3:43 pm
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
August 1, 2021 at 7:25 pm
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
Change is inevitable... Change for the better is not.
August 2, 2021 at 5:54 am
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
August 2, 2021 at 11:37 am
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
Change is inevitable... Change for the better is not.
August 2, 2021 at 11:39 am
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
Change is inevitable... Change for the better is not.
August 2, 2021 at 2:57 pm
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 17 total)
You must be logged in to reply to this topic. Login to reply