One good practice for a DR is that any task should be able to be done by someone outside the team that normally looks after the service. This means...

It is established best practice in the security world that the people who grant rights to a given object should be different to the people who allow people to use...

Another aspect of MAXDOP is that it applies to each portion of the execution plan, not to the whole plan.

If you are doing a SELECT from a single table using...

Having heard an explanation of this from the Microsoft...

I think you need to talk to Microsoft about this.

If your backup gts created using Tape Format 1.240 on one operating system and canot be restored on another, using the...

If you want to script the SQL 2008 cluster install, FineBuild can help. The current release will also create a MSDTC cluster if you want one.

We use transactional replication and have a few updating subscribers. All of our subscribers were updated to SQL 2008 before we updated the publisher or distributor from SQL 2005....

You are right in saying the ownership chaining would have to be enabled in your own DB for its owners to gain elevated rights in master. But it is...

There are a couple of viewpoints I could take over Houston...

1) The missing functionality is serious, and the product is of little use to the enterprise without it.

2) The available...

There are a few possible causes...

1) Faulty install media. This does not often happen, and given the other messages is not likely to be the cause of your problem.

2)...

Are you installing from a network drive or a local drive?

The SQL Server install is not very tolerant of slow drives or slow systems. There are numerous timing tests...

If MSDB has Id 3 then you need to detach MSDB then attach MODEL as DB id 3. In order to detach MSDB you will need to stop SQL...

For SQL Server 2008 (and 2008 R2) you cannot tell from looking at the media if you are installing a 32-bit or 64-bit version of SQL Server. Neither can...

In the main, you have to accept the poor code that some third-party products give to you.

If performance is really killing you, then escalate this to management. Give them...

The entry exists in the Add/remove programs display because at some point in the past you installed SQL Server 2005. The fact you have now upgraded to SQL Server...