Daniel Janik looks into those out-of-memory errors Management Studio blesses us with:
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting to run queries?
You may have noticed that this tends to occur after you’ve opened and closed 40 to 50 query windows. I’ve noticed this when I have had as little as 5 query windows open after having already opened and closed 30 or so other query windows.
It’s crazy that Management Studio is still a 32-bit application after all of these years.