Here is a link no SQL 2000 DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

Here's my 'short list' for tuning:

Round I

DBCC UPDATEUSAGE

UPDATE STATISTICS (with FULL scan) for all tables

exec sp_recompile for all...

It sounds as if you are on the 'bleeding edge' ...

Not a fun place to be at times but very challenging and rewarding ...

Best of luck !

Just a few of more points.

- Floating point is for scientific and numerical computations - stress on scientific here.

- Floating point is CPU specific - remember the Pentium 'floating point...

I have a few more questions to help clarify your situation and then be able to help:

The database is getting huge in size due to expected data growth --> What...

I have 3 words to start with:

Planning, Planning, Planning

These 3 word will be the keys to your project a success. Yes, you have a full blown project in moving this...

GermanDBA, you mention that this is a '3rd party' system By this I assume it is a software package purchased from a vendor. Hopefully this purchase incudes some type...

I am just curious why the 'odd' number 2100 ???

Where there is a will there is a way ...

loner, there have been many posts that you have submitted over the last year or so. Most are in the same vein as this one is.

I have no sympathy...

I would opt to probably reinstall the whole SQL Developer Edition just to make sure things are OK. If you have database you need to save with valuable work I...

After carefully reading each post it seems that there is a very, very small niche for CLR. The IS/IT world has become a victim of the MS marketing machine in...

From Mars to the local 'hoops' court ... WOW !

Am I glad all I usuallyhave to do is use a CICSO VPN and RDP (sometimes Putty for my *nix servers)...

I wish that I had worn my brown boots today instead of my brown shoes :sick: ...

It is getting pretty deep in this thread today 😀 ...

You may have a few other options to this situation that were not mentioned. The first would be to use a logon trigger to check what application is being invoke...