When dealing with a huge amount of data when running queries, frequently returns Out of Memory errors. The following error is displayed :"System.OutOfMemoryException errors"
原因
It happens sometimes when the cache is exceeded by the size of the data to retrieve.
対策
WORKAROUND:
1. Go to Tools | Options | Database | Cache
2. Clear cache and increase memory, (by default is 10 Mb)
3. Click on Apply | OK
4. Restart Toad for SQL Server
5. Return to Options | Database | Cache | >> Verify the new value was saved.
