Giela Monster,

thank you for the feedback. I have another question though . How will one address a table with high volumes of inserts and deletes ? Surely the rebuilding on...

Gila Monster,

thank you for the feedback.But I would like to know if you still have to run the normal index rebuild but you add the online= on parameter in the...

Hi,

we are running SQL Server 2005 Enterprise Edition 64 bit

Good day.

The database is 800 gig in size and we cannot move the data to a warehouse . We cannot purge the older data either .

Thank you for the feedback. Unfortunately we cannot back the database up locally due to space constraints on the server .

Thank you all for the feedback. I have one more question though: If I were to set the max server memory for SQL Server to 6 gigs it shows on...

Thank you for the feedback. We eventually configured SQL Server to use only 4 gig as they wanted 2.5 gig of memory to be free . Well I don't know...

Thsnk you for your comments. I mus also add the application is running in its own memory space on the server and it is using 1.5 gig of memory .

Mohammed, I did that , but we were still able to sign on using PSremote