See this technique posted by Steve Kass

CREATE TABLE dupNulls (

pk int identity(1,1) primary key,

X int NULL,

nullbuster as (case when X is null then pk else 0 end),

CONSTRAINT dupNulls_uqX UNIQUE...

A slightly easier, and generally accepted method is to perform a delete/insert instead of an upsert. For example:

DELETE FROM Destination

WHERE key IN (SELECT key FROM Source);

Or, using EXISTS:

DELETE...

How are you starting the service? Since this is a cluster you should not be starting the service from the services applet. You need to bring the service...

I am not seeing any problems with this - what are the results you are getting?

Well - it really depends on what your table structures are, how they are related and what is the purpose of your queries.

If you want the results in a single...

Is this really the setting you have for max memory?

14 million, 145 thousand megabytes? If so, for a system with 16GB of memory available...

The only way to avoid dynamic SQL would be to create a partitioned view. You could create the view dynamically, and then reference the view in your procedures.

So, you...

One of the things you will have to consider is the additional LUN's that will need to be presented to the cluster. Remember, each instance is going to have...

No idea what you are really asking here - but, you can only have one clustered index per table.

No - views are not materialized. The view definition is expanded into the calling query and used to generate the final query to be executed.

The view definition itself will...

No - each job step is it's own transaction. I don't think you can use transactions because each step could also be using a new connection.

The EXISTS function returns true if there is at least one row returned from the query. Using EXISTS will be faster than a count.

You will see that message while the update is patching the passive node. Again, if there are any users logged into the passive node - the upgrade will hang.

There...

When installing or patching SQL Server in a cluster, it is very important that there are no users logged into the passive node when the upgrade is performed.

If there is...

Steve Jones - Editor (4/16/2009)

---

The VSTS tool is Red Gate's under license.

There are other compare tools, but there is no best one. Try one or two, pick the one that...