What percent_complete does the progress query return? (know that it's not necessarily linear/precise)

What reasons do you have to believe restore will suddenly become faster and complete in a small fraction...

Note: SQL Server Express is not supported as a replication publisher - only as a subscriber.

So backup & restore or a homebuilt process for pulling data to the central...

Do you have reliable, reasonably high-bandwidth communication between the head office and all those satellite offices locations? Transactional replication could cause issues if not.

Another option would be to restore backups...

Employee/Person: Response By indicates a relationship in another table to Employee/Person. It is not an attribute of Employee/Person.  Even less so is Response On datetime. Attributes of an Employee/Person might...

Good point. I got tangled  in the jumping between tables and logical design too.

My intent (not clearly stated) was for table naming.

Glad to hear it!

First rule of tech support. 🙂

That's an ELT (Extract, Load, & Transform) strategy using a staging table, as opposed to an ETL strategy (in which you would do the transformation before importing, loading directly into...

As Scott already suggested, think about entities & attributes.

What are the entities (actors/objects/categories) involved? What attributes do the entities have? How do they relate? One-to-one? Many-to-many? (e.g., can you have...

CPZ Name & CPZ Code appear to be related. Is it one-to-one? (in which case they should be in a lookup table, and only reference CPZ Code in other tables)

Or...

That conversion is going to be fun in SQL 2012. /s

In addition to the usual fun in converting among timezones in the United States, you have the additional complexity that...

Format could be derived like this:

CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)

You indicate output as "Rome Time". What timezone/offset is your source data in?

Were Windows updates installed?

Sounds like a query or data issue. Do the affected reports have anything (e.g, a parameter) in common?

Did something change in stored procedure(s)? New data that might...

They need to get their lawyer on the phone with the application provider.

The application provider seems incompetent at best, and probably unscrupulous and/or struggling to survive with outdated technology. Your...

e.g.,

DECLARE @SNH TABLE
(
cntDT DATETIME,
cntQ varchar(10),
cntL int
);

INSERT INTO @SNH (cntDT, cntQ, cntL)
VALUES ('2001-04-04 10:00:00', 'Queue01', 3),
('2001-04-05 10:03:00', 'Queue01', 1),
('2001-04-05 10:06:00', 'Queue01', 1),
('2001-04-05 10:07:00', 'Queue01', 1),
('2001-04-05 10:11:00', 'Queue01', 1),
('2001-04-05...

It sounds like you just need to use a numbers table or tally function to generate numbers, & use that to generate table of datetimes using DATEADD.

Not sure...