Yeah I do have index's. I also ran the optimizer.
The data has not changed, it is only updated as we add documents and none have been added for a couple of months.
Its not really that much data.
gnomee2
Last Activity: Mar 8 '08, 07:16 PM
Joined: Nov 12 '07
Location:
-
Do you get any errors?Leave a comment:
-
MSSQL Slow Queries on One Database only all others fine.
Hello Everyone,
I have a strange problem that I cannot seem to solve. I have two server running Windows 2003 MSSQL on one IIS on the other.
Out of the blue I have slow queries that cause asp script timeouts and I cannot figure it out. I have moved some test code to other sites on the server and still have these long delays.
I have tried dropping the tables, then the database entirely and restoring and...
No activity results to display
Leave a comment: