Steve Jones - SSC Editor wrote:
FWIW, the 8KB schedule is online: https://eightkb.online/
Mr. Moden presenting, if you can make it, at Level 8192. Well above the 400-500 level of other sessions.
Heh... that level was one of the choices in the Sessionize as the "Insanity" Level. Since my presentation is incredibly heterodoxical to a lot of "knowledge" that has been out there for decades, I figured that was the appropriate level. 😀 To summarize (but please do read the abstract by clicking on the entry), I "DESTROY THE MYTH OF GUID FRAGMENTATION" and "lay waste to what people are currently calling “Best Practice” index maintenance".
If you haven't seen this one before, it'll totally blow your mind. For example, did you know that you can use Random GUIDs to PREVENT fragmentation for months at a time? Have you ever heard of someone inserting 100,000 rows per day into a RandomGUID Clustered Index for 58 days (a total of 5.8 MILLION ROWS) with <1% fragmentation and doing NO INDEX MAINTENANCE for that whole 58 days? 😀
That's not all that's covered. I also show you how and why a lot of ever-increasing indexes fragment so quickly and some of the things you can do to fix it and why you should probably avoid the use of NEWSEQUENTIALID()
You'll also get a copy of the sp_IndexDNA™ tool that I created to allow you to actually see what an index looks like in a graphical form.
Come one, come all. Tell your friends. Make sure that you bring a water-cooled helmet... you're going to need it. 😀
is pronounced "ree-bar
" and is a "Modenism
" for R
ow.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".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
Helpful Links:How to post code problemsHow to Post Performance ProblemsCreate a Tally Function (fnTally)