Definitely agree with Kevin to patch up if it isn't already.

Other than that, there's no "generically make everything run faster" option.

C'mon, let's see the execution plan! 😀

Looks like this is something that's been fixed in SQL 2005 - I've played around with compatibility and you can't change it.

Technically speaking, SQL 2000's answer was incorrect as the...

As far as I'm aware, Weblogic just uses JDBC drivers - these support pretty much any version of SQL Server. I seriously doubt that there's anything fundamentally incompatible about it,...

I'm not sure you'd be able to do that accurately, it depends on a lot of factors. It's may not be IOPS dependent as much as overall throughput as it...

I'm not sure there's an easy way to accurately assess it other than try it in a test environment. It's going to be an intensive operation as not only will...

Doesn't surprise me.

Synchronous mirroring to a different location means that a transaction can't be commited until the transaction has been received at the other end and it has signalled...

No. Easily tested, scope_identity() will not return the identity of another procedure in the same session:

CREATE TABLE test(col1 INT IDENTITY(1,1))

GO

CREATE PROCEDURE proc_1 AS

INSERT INTO test DEFAULT VALUES

GO

CREATE PROCEDURE PROC_2 AS

EXEC...

Nice blog post Wayne - shame the performance doesn't look great at the moment for a common use-case. Hope they sort it out before RTM - I don't recall the...

I'm not sure client-side validation is a good fit for this problem as it needs comparison with other data that's in the database. Even if you went to the hassle...

There's a link here about the remnants of a 32-bit install of SQL Server that was causing issues:

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/27694808-b0d2-4a71-84a3-6389d84ad6a3/

Although if you've re-imaged and are still having issues, I'd say it's time...

Does the event viewer post any other error messages than the one above?

Anything in the SQL Server log directory?

You can start the service from the command line with a -c...

That doesn't look like the full list referenced on the link I provided, but can't you just add the service account into the predefined local group that was created by...

That sounds like a well planned change 🙂

The SQL Server Setup creates groups with the appropriate privileges, this article lists what those individual permissions are. Obviously it may also depend...

Ah, sorry, misunderstood. Well, it depends on how you're partitioning your data across the 3 seperate volumes I guess, but it does sound like your drives are underscaled for the...

Your disk configuration is well below par for dealing with TB+ databases (I'm confused how you have a 3 disk mirror in any case), but 7.2k hdd's without any striping...