My 1st Blog – out of memory exceptions in SSDT… yes its technical

When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception (especially if you’re retrieving over 1 million rows+). To resolve this, go to the TEST\Test Settings\Default processing Architecture menu and select ‘X64’, this will give you a massive increase in memory usage with in Visual Studio and testing.


Leave a Reply

Your email address will not be published. Required fields are marked *