- probably performing a little maintenance (rebuild indexes, sp_updatestats) will help out !

- Maybe this thread will help our: http://www.sqlservercentral.com/Forums/Topic645979-7-1.aspx

- How to manually remove a replication in SQL Server 2000 or in SQL Server 2005

http://support.microsoft.com/kb/324401

"...constantly autogrowing..."

- Run dbcc opentran in the troublesome database and see what it comes up with

- I've seen this kind of behaviour a couple of times in some of our...

just keep in mind to set "max server memory" to the amount of ram you allow it to use on the box.

Leave enough ram for the other processes running on...

it is possible your default collation of the userdb has been altered.

Script the dbo.sysusers table of the userdb including collation information.

You may find a different collation,..

You need to enable AWE if you want sqlserver to use more than 8GB of ram.

have a look at:

- http://sqlserver-qa.net/blogs/perftune/archive/2007/12/28/3048.aspx

- http://support.microsoft.com/default.aspx/kb/274750

- BOL ref: http://msdn.microsoft.com/en-us/library/ms190673%28SQL.90%29.aspx

your database is not created with the same collation as your sqlserver instance itself.

How to resolve it ?

This issue goes further that just with sp_adduser.

It basically means your db has...

With partitioning the first question one should pose is:

What kind of horizontal split of data would support the goal I aim for.

Since your main query uses a date ranges...

- You need to keep in mind, this event driven mechanisme is asynchrone by design. It may occur the messages are being processed a little time after the event occured,...

That's indeed what I intended to John ! Thank you for stating it more clearly !

btw I wasn't aware you guys did already work on the subject on

anohter thread.

To...

Before actually start using partitions, you really need to read technical docs about it !!

If you don't keep the guidelines in mind, you may end up with bad performing objects,...

Good Job !

Nice article, well documented, good refs.

As documented, the general attitude for FK-indexes sould be : always implement FK-indexes, unless one can prove a particular index hurts, and then...

Sander A. (11/9/2009)

---

.. simply suggesting I should think more carefully about designing my tables is easy to say: The table already existed before i started working here, so i'm just...

please post in SQL2000 forums for SQL2000 related questions.

@@version info does matter !! Please provide it.

- Did you perform any maintenance after the restore ?

- did you update statistics ?

-...

altering float to decimal(n,m) will cause your full table to be rewritten !

Best you can do to take control is - as Gail advised - create a new column (decimal)...