Hello!

Is the log file physically consistent? You can try copying it to a different physical path on the SAN (if the space so allows) just to make sure that the...

Can you post the test scripts you used for the test so that the scenario can be reproduced in-house?

Hello!

I think John raised a very good point by mentioning that "Being UK-based, the Michigan bug could lie undiscovered on our systems for many years!". That brings the customer's geography...

Hello!

I have been working in a Sustenance team for the last 6 or so years - ever since the product was only supporting SQL 2000 SP3. Over the years we...

The SQL2005 version of the script is:

/*

Major Assumption Here:

The "SatDayDelivery" BIT should be in the Pickup table and not in the Routes table.

The way I read it, the Routes table...

See if the following does the trick. I have used TABLE variables instead of actual tables just for the POC.

/*

Major Assumption Here:

The "SatDayDelivery" BIT should be in the Pickup table...

Hello!

Shouldn't your "SatDayDelivery" BIT be in the Pickup table and not in the Routes table?

The way I read it, the Routes table associates a staff member with a particular route....

Hello!

Can you post the CREATE TABLE scripts and some sample data generation scripts as well?

A couple of issues with the question:

1. The choice #1 (A) states "ALTER TABLE...." while the answer points to BOL on ALTER TRIGGER

2. The question does not clearly specify the...

You can have one maintenance plan with multiple sub-plans. I therefore believe that the answer to this question is "1", not "2".

The article that the author has referenced clearly states that there are only two choices - "restore it from a backup or recreate it". Nowhere does any futher instructions refer...

Sharing passwords with the project owner/executive sponsor (in case of an under-development project) and/or with the Executive team (for production systems) in a sealed envelope to be kept in a...

Use COALESCE(Field1,<<Replacement string>>) to avoid the effect of NULLs

Basic joins....

Key is that you need all Services - irrespective of whether or not there was a sale. In such cases, start with the table from which you need all...

You can validate this using Excel as well. You will find the same thing in Excel also (Refer attachment)

Excellent post!