I have recently "upsized" my database to an SQL Server because it was reaching the 2 GB limit. I was hoping that the move would speed up the database and prevent it from crashing because of it's size. The "upsizing" went fine, and I was able to run my queries afterwards. However, when I try to run a delete query or an update query to modify the data in one of the tables on the server, it runs forever. I tried to run a delete query yesterday to clear a temp table and prepare it for updated data. Before I "upsized" my database, that query would run in a matter of minutes. Yesterday, it ran all day long and still did not delete all records (I'm not exaggerating either - I started the delete query around lunch and at 7:00 pm, it still wasn't complete). Can I not add and delete data in a table housed on an SQL Server? What do you recommend?
Any assistance you can provide would be greatly appreciated.
Any assistance you can provide would be greatly appreciated.