sqlvogel (12/4/2013)

A primary key constraint is a uniqueness constraint. Would adding a third key as you suggest really make any difference to the question of which ought to be "primary"?...

Why would someone need a primary key for husband and wife?

None of the two makes a good primary key, but both should have a unique constraint - if such a...

The query seems to be correct.

But the problem description as well as the answer is there, too:

One solution is to increase the number of characters retrieved from the server for...

I don't recommend to rely on a phone call to create the snapshot.

Usually, working hours of Dev and Prod are not identical. It won't be too long until the Dev...

Objection, your Honor!

The physical storage on disk is based on the clustered index,...

A Primary Key is used to identify a single row based on the "business rules". This key is used in foreign key references to ensure logical consistency of the business...

One option would be to run the code as a different user with elevated permissions using the EXECUTE AS clause.

But this would require to replace the dynamic SQL with hard...

Like Jeff already suggested: it might be required to recompile the code since the cached query plans might still not reflect the new index.

Jeff suggested the DBCC FREEPROCCACHE followed by...

Would it be an option for you to create a view with the xml formatted result set (instead of storing it "physically")?

Might help to deal with the data in a...

Check with the database owner if the permission to modify those stored procedures can be granted.

What exactly is your question?

Based on the error message the named SQL Server instance W6010_01 at the server W6000 was not accessible.

There are numerous possible reasons for that message. You...

from my point of view the first step would be to figure out how it happened and to close that "back door". Otherwise you might get faced with the very...

I'm not sure what your template looks like...

Do you want to have each table loaded to a separate Workbook?

If so, you could have a look at this link how to...

I'd go with a separate table with the columns ObjectiveId (as a foreign key reference to the current table), OutcomeId, KSA_aspectNo, KSA_AspectValue together with a column referencing the related.

I'm not...

I guess the big question is:

What kind of validation is performed?

Would it be possible to store the "bunch of rows" to a temp table with an additional column to mark...