allmhuran (8/23/2012)

Using this solution:

The status of a region is held in the relationship table.

A region with no offices assigned to it will have no rows in...

This is why I always write date literals in the form 'yyyymmdd' without separators.

Getting others to realise the importance of doing so is another story.

A questoin; out of curiosity:

You quoted some PerfMon stats on your production environment.

Given your analysis, would I be correct in assuming your produciton environment already runs an array of >...

I have a concern with this approach.

Since the objective is to "get data from a file into a (staging) table with as little fuss as possible", I presume you want...

More important than whether or not planned maintenance is included in downtime is: that it is clearly and unambiguously agreed.

From the customer's perspective, consider which is preferred:

- A system with...