Take the @Tsql variable out of single quotes.

SELECT Top 100 * FROM OPENQUERY (ENIQSQLSERVER, @tsql) Hourly

One thing I noticed and am curious about is, this physical machine has 8 processors and looking at the %Process Time for each processor only Processor(0) has data filled in....

Markus, is there virus scanning or some other disk process in place on the disks you want to restore it to?

A few more questions.

Is there common data between the two databases that needs to be in sync? Or, is this data completely separate?

If there is data that needs to...

Number one, you need to become very good friends with your network people!

Where are the user names and passwords stored? If they can be stored in the USA database,...

In the table Tab06_SubTab02, you have field defined as an integer.

The corresponding field in the select statement is a smalldatetime.

Even though there are no rows returned, SQL still...

The execution plan tells it all. This query is performing a table scan. In order to get one row, the query optimizer needs to look at all of the...

Probably the fastest thing is to take new backups, and restore those.

Are all three .bak files valid SQL Server backups? .bak is only the default extension. Backups can be named anything.

Try this:

RESTORE VERIFYONLY

FROM DISK = 'FILENAME'

You should get this...

New Born DBA (7/17/2014)

Since the DB is only 10 GB, you may not see a need for more indexes. At this size, unless you have a server with 512...

1400 tables, 2300 indexes. That's about 1.5 indexes per table. Actually kind of a low number, IMHO.

Does this seem normal? Define normal. What works fine for...

The "rules and regulations" are specific to performing an in-place upgrade, which you are not doing. With a new server, you have a lot of options.

For starters, you can...

The questions are:

What EXACTLY are they going to do in this time?

Do you get an initial assessment?

Do they provide ongoing metrics about your servers?

Do they make recommendations based upon...

It sounds as if you are considering outsourcing your DBA activities, and are trying to determine if their estimate / proposal is a fair one.

A few things to think...

This may be the issue:

WHERE ID = @codeCnt;

Something tells me that the value of ID does not correspond to the value of @codeCnt

ID is an identity. How many times...