Compared to your environment, mine is really small. I have to support close to 50 prod Dbs.

I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the Testing environments...

What kind of error you are getting? If you post the error message might be able to help you.

Thank you both Lowell & Sean for pointing my mistake out, I was thinking about the storing data & haven't read the post properly.

As Grant Fritchey said single update statement can not cause deadlock to itself. So run sp_who2 which will give you what processes are running at the time. Look for blyby...

If you create Clustered Index on RECORD column of new table. It sorts and stores data in the clustered index key.

Not much sure what the question is.. but the below url might slow.

http://guozspace.wordpress.com/2012/05/31/create-htmlxml-emails-using-sql-server/

Look at the attached xls and check for the fields marked in red and answer me if you have mapped them right.

Change name of CTE to something else other than DTAGatHERTZ_RO.

Tell me what error you got? Also I need data in the form of script where I can insert that in my environment without writing the code.

The world is going virtual and even we love to run SQL on Actual hardware, we can not stop it. There are so many factors which is driving virtualization.

I would...

What error it is giving. You have given data for only MatNat table, so I can't replicate it.

But Check the value of Hotel, Nation & Match Table to see if...

I totally Agree with Gail on that it will be total waste of resource if you do such kind of stuff. But if you really want to do that, you...

Because you have made foreign key as MatchID, where as it should be Venue ID.

CONSTRAINT fk_VenueID FOREIGN KEY (MatchID)

It should be :-

CONSTRAINT fk_VenueID FOREIGN KEY (VenueID)

You create 10 rows...

I would not suggest going back to SQL 2008 by generating scripts etc. I would rather figure out what is wrong with the current SQL 2008 R2 instance as SQLRNNR...