Most Valuable Yak (Rob Volk) Blog

…and other neat SQL Server tricks

Queerie Memoree Spils

Did you know that if you run a query in SQL Server, and it processes it as a hash match, and there's not enough memory to fully process it, the memory will spill to disk?  You can find out all about it here.

Note: I know this makes even less sense than my usual blog posts do, so for more information, check out Jen's Awesomesauce blog entry about it.  (Please don't sue me Jen!)


Legacy Comments

re: Queerie Memoree Spils
I couldn't keep up with all of the tweets about #sqlsue. This guy has some balls to sue Adam!

@SQLWorkshop (spun up today) is pretty clever.