Forrest
@tsqladdict
Followers
261
Following
16K
Media
17
Statuses
241
Joined January 2017
Woah, 10 years today of working with SQL Server. Many thanks to the many people who have helped me along the way.
0
0
6
I found columnstore key lookups were a lot slower than regular key lookups, and wanted to figure out why:.
0
1
6
RT @natfriedman: Ten months ago, we launched the Vesuvius Challenge to solve the ancient problem of the Herculaneum Papyri, a library of sc….
0
15K
0
And of course the Left Anti Semi Join. You sound smart if you put this on your resume.
0
1
6
Ok, let's try some logical join visualizations that aren't Venn diagrams. To start, the Inner Join:
4
5
11
RT @SQL_Kiwi: If you're running SQL Server 2022, hold off installing CU4 if you're using the Parameter Sensitive Plan Optimization with Que….
0
21
0
RT @MSAzureCAT: 🌟Today's @MicrosoftLearn Contributor Spotlight: @Zikato25 is a Sr. Database Engineer, who specializes in performance tuning….
0
9
0
RT @SQL_Kiwi: The second instalment in my SQL Server lock escalation series, featuring:. 🔹 A scan escalating some locks, but not others.🔹 1….
0
10
0
RT @SQL_Kiwi: How and when lock escalation is triggered in SQL Server. Spoiler: it doesn't happen at 5000 locks.
0
19
0
