I've worked on about a dozen systems, some that I helped design and some from third parties. There hasn't been _any_ database enforced relational integrity in any of them....

This has been annoying me forever. They really should improve the flexibility of the site layout. It should be easily fixed.

The columns in the QOD table seem...

I got this right, but it looks like there are two correct answers. I'm not sure that there is any argument for a "best" answer.

Just to add a bit...

It is common to build a view that contains a JOIN to the role-permissions table and adds the extra criteria. The report query would...

Is D better for some reason other than "easier"?

This one has two correct answers and points should be given for either answer.

I'd like to see some references because...

Do your admins enforce policies, especially on IE? I found that our network guys started allowing all cookies, etc. through a registry change pushed out to all machines.

The other...

Also, bar codes can change especially when a wholesaler or repackager changes manufacturer or there is a merger or acquisition in the supply chain. This may not apply in...

Also, the fewer joins you use the better. I liked the solution that used the CASE statement. I recommend that because it seems more logical and minimizes the...

Hyperthreading is not the same as adding a processor and doesn't work for every application.

The problem is a basic issue with hyperthreading and the software's design. These...

There should be no technical obstacles, but depending on requirements there are several possible solutions.

How often must the data be transferred; nightly or near real-time? How much data will...

I took a guess and, apparently, guessed wrong.

Answer 1 implies that the query shows an intent that is not actually reflected in an otherwise properly formatted query;...

If the value of the database structure and procedures is very high, then you must not yield physical control of the database instance, i.e. files, to the vendor. Only...

GilaMonster is correct; there is a one sentence mention here but not in the Trace Flags topic where all the other trace flags are documented.

--Peter

This trace flag is not mentioned in books on line. It seems rather foolish for MS to document mirroring there as if it were a supported feature.

Oh,...

But it looks like you have to have a 32-bit server to do the migration first, then you can move the SSIS package over to the 64-bit server.