TRUNCATE TABLE master..sysdatabases

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

Tuesday, October 18, 2011

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!)


posted @ Wednesday, October 19, 2011 12:00 AM | Feedback (1) | Filed Under [ Stupidness ]

Powered by:
Powered By Subtext Powered By ASP.NET