There is no existing column orderstatus so that last option is not possible.

Hugo,

I don't believe I can upload any files here to show you screen shots can I? So, I will describe exactly what I did.

When I got the initial error about...

Thanks for replying Hugo; however, I am still confused with regards to the Primary Key behavior.

Perhaps you or someone else can clarify the following for me? Using the 2012...

You are spot on correct jcclementz 🙂

The database option ANSI_NULL_DEFAULT was set to off which I confirmed with the following:

SELECT is_ansi_null_default_on

FROM sys.databases...

I knew the question was trying to test one's knowledge about COUNT(*) versus COUNT(aSpecificColumn), as I have been caught by this previously.

The only problem I have with this QoD, is...

The question is not detailed enough, cannot be answered properly and should be revised. As previous posts state, there is a "minimum" requirement for memory, but memory really depend on...