IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

Thank you for the feedback.

Now, let's have a virtual pint on behalf of your solution :w00t:

maybe your table was pinned on sql2000 ?

that nolonger exists on sql2k5

- 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,...