We are new to MS SQL 2000.
Monday we had a power loss that shut down the servers (including SQL server). Since then the SQL seems to be sluggish, althought the server itself seems to be running fine. Most forums are saying to run a DBCC DBREINDEX (which we have never done but probably should since we have over 100,000 records in the table and we have been modifying and deleteing items for 8 months).
Question: How do you run DBCC commands?
Thanks for the help.