Usually index rebuilding needs to be done only on tables with a lot of inserts/updates/deletes because it makes indexes and statistics not up-to-date and query optimizer stopping its usage.

SAP, PeopleSoft...

Instead of waiting report you can use SSMS and in the index properties of the specific table you can see fragmentation on table by table, index by index. Also, you...

What is the exact error? Locking can be caused by application not by user's action. In this case more work needs to be done. Try to look at locking and...

What is number of locks on the server? Is it configured dynamically? Check article at http://msdn.microsoft.com/en-us/library/aa258769(SQL.80).aspx and http://support.microsoft.com/kb/323630. Both articles can explain a lot.

Sorry, I forget to say that online indexing is available ONLY in the Enterprise Edition. So, if you are on the Standard Edition - you are out of luck and...

I would check first fragmentation on indexes of the table. If it is low on some indexes I would rebuild only necessary ones and not all of them, or you...

I hope you mean “Backup” when you say “Archive”. However, database backup has .BAK extention and not CAB.

Anyway, you can detach database from SQL Server, copy files (mdb and/or ldf)...

I have dual BS in Computer Science and Electrical Engineering plus Masters in Business Administration with focus in Finance. I am 100% sure that my degree gave me advantage over...

Whatever data model is better than no model at all. I would try to review data model and understand what developer wants to get using function/store procedure. I’ve seen many...

Any user within sysadmin role is able to do the same as sa. This is usual misconception. Good luck 🙂

You need to create linked MySQL server in MS SQL Server. In this case you will see if ODBC driver available when you use wizard to created linked server.

http://msdn.microsoft.com/en-us/library/aa933141(SQL.80).aspx

Number of accidents,

10 worst queries;

Number of failed jobs;

Max CPU utilization,

….

Best practice: never ever use sa for anything. Password for that account should be saved in the safe and no one can use it for any purpose but true emergency.

I had exactly the same problem, the same discussion, and the same uncertainty over the way to design database. I have client with 1500 databases that are exactly the same...