I have disabled intellisense and testing. So far, no lagging. That is a good sign.

Ok. Thank you. I was hoping for some cool way at the database level to do it. The text search of webpages takes a long time to...

shrinkfile will let you go below the initial size. I shrunk the file and tried to lower the initial size, stopped and restarted the sql service and it went...

When I do an sp_recompile 'spname' and then run the stored procedure, it takes about 2 minutes to run. If I execute it immediately after that, it takes 2...

I am having a similar issue with several stored procedures. I am doing a large data load at night. Is there a way of running these procedures after...