Forrest

This needs votes: zoom results in SSMS developercommunity.visualstudio.com/t/Zoom-the-res…

Woah, 10 years today of working with SQL Server. Many thanks to the many people who have helped me along the way.

@erikdarlingdata Great post, but before I comment I need you to install this collector script and send me gigabytes of irrelevant logs. Note: this response is sufficient to qualify me for the reading-a-friend's-blog SLA.

📬 The Decline in Microsoft SQL Server Support: Why Your Business Deserves Better, And How I Can Help: ift.tt/gY1Wv9J 📬

I found columnstore key lookups were a lot slower than regular key lookups, and wanted to figure out why: forrestmcdaniel.com/2024/08/05/why…

A short new post: forrestmcdaniel.com/2024/06/12/sol…

@erikdarlingdata Sounds like a dot dot dot product

oh, an open source vector database, you say?

Ten months ago, we launched the Vesuvius Challenge to solve the ancient problem of the Herculaneum Papyri, a library of scrolls that were flash-fried by the eruption of Mount Vesuvius in 79 AD. Today we are overjoyed to announce that our crazy project has succeeded. After 2000 years, we can finally read the scrolls: This image was produced by @Youssef_M_Nader, @LukeFarritor, and @JuliSchillij, who have now won the Vesuvius Challenge Grand Prize of $700,000. Congratulations!! These fifteen columns come from the very end of the first scroll we have been able to read and contain new text from the ancient world that has never been seen before. The author – probably Epicurean philosopher Philodemus – writes here about music, food, and how to enjoy life's pleasures. In the closing section, he throws shade at unnamed ideological adversaries – perhaps the stoics? – who "have nothing to say about pleasure, either in general or in particular." This year, the Vesuvius Challenge continues. The text that we revealed so far represents just 5% of one scroll. In 2024, our goal is to from reading a few passages of text to entire scrolls, and we're announcing a new $100,000 grand prize for the first team that is able to read at least 90% of all four scrolls that we have scanned. The scrolls stored in Naples that remain to be read represent more than 16 megabytes of ancient text. But the villa where the scrolls were found was only partially excavated, and scholars tell us that there may be thousands more scrolls underground. Our hope is that the success of the Vesuvius Challenge catalyzes the excavation of the villa, that the main library is discovered, and that whatever we find there rewrites history and inspires all of us. It's been a great joy to work on this strange and amazing project. Thanks to Brent Seales for laying the foundation for this work over so many years, thanks to the friends and Twitter users whose donations powered our effort, and thanks to the many contestants whose contributions have made the Vesuvius Challenge successful! Read more in our announcement: scrollprize.org/grandprize

New SQL Server blog entry: Why Batch Mode Sort Spills Are So Slow (sql.kiwi)

Last and least is the Right Join:

Ok, let's try some logical join visualizations that aren't Venn diagrams. To start, the Inner Join:

And of course the Left Anti Semi Join. You sound smart if you put this on your resume.

Ooooh, row multiplication. Time for the Left Semi Join:

Of course, next comes the Left Join:

Community captions requested:

@erikdarlingdata Time for some execution plans

how have i never seen this before

@erikdarlingdata That slide picture is hilarious!

📬 Index Tuning Essentials Spools: All About Spools In SQL Server Query Plans: ift.tt/iEtI4Jo 📬

📬 T-SQL Tuesday: Code That Made You Feel A Way: ift.tt/zqjyuOE 📬

@erikdarlingdata Fat fingering!

Sure, everyone has made the “bugger pool” typo, but how many of you have made the “butter pool” typo?

If you're running SQL Server 2022, hold off installing CU4 if you're using the Parameter Sensitive Plan Optimization with Query Store on, OR if you have indexes with a descending order key and you like your ORDER BY clauses to work properly. If you've already installed CU4, turn on global trace flag 13166 to fix the descending key issue only. brentozar.com/archive/2023/0…