Search results for query: *

Hi In the last few days we have been experiencing serious performance problems with a database on SQL server 7. Query/ Update & Backup times have been increasing exponentially. ( Backup from 1 hour to 13 hours etc). There has been no radical increase in the amount of data being loaded into the...

Hi Any thoughts on this one? We recently added a password to user SA on a server(server a) which previously had none (null). We had another server(server b) set up with this server as a linked server, but failed to change the sa password on the properties of the link on the other server. This...

I have just upgraded my pc from ME to XP( clean install) , and have tried to re-install my office '97. I get a message telling me this is an upgrade and I need some qualifying software to complete the installation. I am fairly certain this is not an upgrade, but how can I tell. I had no trouble...

Hi I have a problem with sevral update scripts having massively increased in run time : The scripts updates one column on a table by joining to another table of the same size and then joining to another smaller table the following is an example: UPDATE AGG_10_TT_DATA SET PUB_ISBN_CHECK_SUM =...

Hi I am looking at putting in place a backup strategy that will allow a rapid switch back to yesterdays position, and would welcome any comments. This is the situation: I have a large ( 150gb) multifile database which is updated by a batch job once a day. If there is a problem with the...

A query which we run daily for the last two months and which took 3-4 minutes has over the last week jumped to a 33 minute run time. When the query was run the system was not working particularly hard and most of the rest of the system was performing OK. I pinned it down to a particular table...

Hi I have a query which runs in about 7 minutes, when I add another column from a simple (small) lookup table joined to one of the other tables already in the query the query time drops to 2 minutes. When I examine the query plans for the two queries the major difference is that the faster (but...

I have a weekly database maintenance job which amongst other things rebuilds all the indexes, this job takes about 8 hours & so if it is still running during 'up' time it has a major impact on the users. I'd like to be able to quit this job if it overruns or at least be able to give users an...