I have a large database with a table of 200 Million records stored in SQL Server 2008 Standard.
The server that holds the SQL Server has the following specs;
Windows Server 2008 R2 Standard 64-bit.
Memory = 500 GB with 220 GB used by the database.
SQL Server 2008 Standard Edition
At runtime when I try to open a column from the table;
select ConsultationGuidDigest from dbo.Consultation
It failed at record 33,554,432 and throws the error message
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.
I googled and the option of output the results as text - same issue
Output the results to a file - is not an option I want to go ahead with with the tasks I have.
If, I need to upgrade the specs for SQL Server or do anything to accomodate this so that the tables could open ok - please advice
Thank you in advance