Forget DBCC TimeWarp. I just discovered DBCC PayIncrease.:-P

For a DWH, I would not put Analysis Services (Cubes) and the Datawarehouse on the same server. I'd go with 3 servers here.

The problem is clearly defined in the error message. You're not passing in the @user parameter which is a required parameter.

xp_findnextmsg: Procedure expects parameter @user, which was not supplied.

xp_readmail: Procedure...

Actually, the terms "principal" and "mirror" are used to describe both...

The problem with this scenario isn't the load that the mirrors put on the server. The problem is what happens if you have to fail over all databases to the...

You can also upgrade to SQL Server 2008 and...

Occam's razor says that the obvious answer it ususally the correct one.

It's a simple fix. You simply need to schedule the process to occur more often. That's it. You don't...

If your differential backup is almost the same size and takes almost the same amount of time, then almost your entire database is getting updated in between. If you are...

Well said, SQLGuru!! I think many of us were thinking it and just not saying it.

Using nolock is helpful, but using rowlock won't help.

SQL tries to use rowlocks for inserts, deletes, and updates. And if SQL thinks that it needs to escalate the lock, it...

Whether it is a table problem or a query problem, the next step is the same. Like you said, identify the queries having problems and figure out why.

Did you notice which database it is in? Using the above query, the database ID is the first number in the resource_description column. You can get the name of the...

Also, what game is it? If it's one that some of play, someone may be willing to donate their time so that their game will run faster. 😀

What database is experiencing the page latch waits? If it is in tempDB, then this could be a sign of tempDB contention, and I would not be surprised if your...

You can switch to asynchronous using the Alter Database command on the principal server:

Alter Database <DB Name> Set Partner Safety Off;

And then to switch back:

Alter Database <DB Name> Set Partner...