TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 51, comments - 60, trackbacks - 14

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

Print | posted on Wednesday, October 19, 2011 12:00 AM | Filed Under [ Stupidness ]

Feedback

Gravatar

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

Powered by:
Powered By Subtext Powered By ASP.NET