I was wondering how to calculate the memory requirements to deal with larger tables. I have a table with one billion records. The table consists of an int column (Primary Key), a uniqueidentifier, and several bit columns. I
removed the primary key while we inserted all the records to improve the insert time, but now I'm having a problem regenerating the primary key. I run the following command to create the primary key:
It gives me the following error:
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
The statement has been terminated.
Msg 802, Level 17, State 20, Line 1
There is insufficient memory available in the buffer pool.
I also get the "insufficient memory available in the buffer pool" when I try to query the table. I only have 4 GB of RAM which I suspect is not enough to deal with large numbers of records. I would like to know how to calculate the necessary
RAM and if needed, how to properly configure SQL Server to process this large table.
I appreciate your help.
View Complete Post