How long has it been since the issue last occurred (6 months)?

How long has it been since you installed SP3?

Do you remember how to re-enable the trace flags?

If you are...

Alternatively, script the tables and indexes from both databases and then use something like beyondcompare to see if / where there are differences

RedGate has a tool called SQLCompare that can do this for you.

Thx - this will prove useful in the new environment i just inherited.

I would like to be able to attend more sessions. Looks like a lot of good stuff being presented.

I'm sure there is. If not in Jersey then maybe in the Big Apple. Google should be able to bring up plenty of results for your area.

The question asks for the "best" thing to do. Probably should have been worded as "will give the most performance boost."

I would not use Raid 0 by itself.

Jeff Moden (8/31/2009)

---

CirquedeSQLeil (8/31/2009)

---

Corporate policy may decree it, but there should be some controls in place allowing end-users a little freedom to finish up the current task. It doesn't...

Learned something from this one - nearly 5 yrs after it was originally asked.

Decided to test it since the clue was in the question and the size limits were there.

Maybe it is because i am late on this one, but according to Technet

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

The max addressable with SQL Server and W2K Data Center is 32GB

Does that particular user have any other processes running?

I have seen in the past where a user was connected via SSMS and the Application showed as Microsoft SQL Server. ...

Try to login to the database using SSMS with the webuser and see if that works.

If you are not able to get in, check to see if the user might...

Michael Valentine Jones (8/31/2009)

---

This script gets the file information for every database on a server, and inserts it into temp table that is queried multiple ways to give various levels...

With so many tables, and the size of DB included, something I have done is to create multiple filegroups. I separate the tables out into these filegroups and then...

Jeffrey Williams (8/31/2009)

---

Do me a favor - lookup REPLACE in Books Online and post what you have tried so far. I am more than willing to help you out,...