TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks

posts - 48, comments - 58, trackbacks - 14

My Links

Article Categories

Post Categories

SQL

<< SQL Saturday #89 in Atlanta! | Home | T-SQL Tuesday #025 – CHECK Constraint 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!)

#sqlsue

Feedback

# 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.

10/19/2011 12:04 AM | Tara

Comments have been closed on this topic.