You shouldn’t use table variables for huge data... temporary tables or actual tables are better.

Few Questions:

•Is it in Windows Authentication Mode or Mixed Mode?

•With which account you are trying to login? The same you used for installation or different?

•How did you configure the SQL...

Kiran... Please take it positively. Professionals here are volunteers and can’t help you if you can't assist them in helping you.

DDLs, SQL Scripts, Execution Plans are required for Performance Tuning...

Few more options:

BULK INSERT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188365.aspx

bcp Utility

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Please keep in mind...

Microsoft Certification Exam Policies

http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx

Overview (Service Broker)

http://msdn.microsoft.com/en-us/library/ms166104.aspx

It’s a nice discussion but I see less practicality in it. Please look into the example that Joe has shared.

Do we really need to update Orders table based on Order...

If the database has high transaction rate then log backups with 6 hrs frequency are not sufficient. Even if transaction rate is normal (few updates in hrs, data loss accepted...

I am sorry I didn’t get you.

I am writing my understanding; please correct me if I am wrong. You have one source (base) database and two copies of it....

Sorry to disagree with you Johan... It looks like 5GB database.

Per BOL:

READ UNCOMMITTED

Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it...

"NOLOCK" hint is the culprit here.

Does the Backup DB & Replicated DB have same database schema (tables, indexes etc.) and same data volume? In simple words, are they identical in all aspects?

Few Questions:

•Do you really need all the columns in SELECT clause?

•7 Inner Joins with 40M records table and No WHERE condition. Do you need all data?

•What does it return? sp_spaceused...

It depends. If a recompile which takes few milliseconds and results in query to return resultset in minutes (originally hours), the choice is very much clear.