TRUNCATE TABLE master..sysdatabases

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

October 2011 Blog Posts

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

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

Powered by:
Powered By Subtext Powered By ASP.NET