DBCC DBREINDEX may help but it won't be enough.
You will need to get out Sql profiler to find those poorly running queries.
If it's 3rd party s/w...
The sql optimizer in sql2000 is different from sql6.5, hence the indexes you used in sql 6.5 will probably be unsuitable for sql 2000
Also you will...
Response to Errorhandler: Have you just migrated from NTSQL6.5 (performance very quick) to w2000sql2000 (performance very slow)?
Thanks for that information
I need to produce a report that lists tables by their size with information about their
Are there any sprocs that do this kind...
We are currently trying to use replication in our application. Do you know what tools are
available to monitor it if it goes wrong. (i.e...
Separate names with a comma.