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
Hello All, I need to produce a report that lists tables by their size with information about their indexes. Are there any sprocs that do this kind...
Hello All, 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.
