Hash Join Memory Grant Factors
Remember when that old DBA told you not to SELECT *? Erik Darling explains why.
2018-04-26
2,943 reads
Hash join
Hash Joins on Nullable Columns
Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.
2015-11-16
3,593 reads
Blogs
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
South Kerala Tour Packages
South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...
Black Corgi Chihuahua Mix – Unique Look and Personality
Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers