Is there a good reason to only use XML files? Replication might be a good way to solve the problem (the details will decide which type).

One other difference is in the sorting ... if the column is included then it won't influence the order of the index records.

I would add that you do need to make sure you have sufficient peak network bandwidth for mirroring. Also it must run using full recovery model.

There are no UTF-8 character types in SQL so you will be using unicode types. Every character stored will take 2 bytes instead of 1. As to the...

You didn't mention SQL2005, so upgrading to the MCITP might be worth looking into. The certificate in itself is mostly meaningless, but the knowledge that you will gain from...

Magnetizing a CRT monitor is always fun if the owner doesn't understand degaussing. Less fun when you realise that the monitor has no degauss button.

Nothing beats shoe polish on...

Steps:

1) Read books/magazines/articles on SQL Server

2) Take the test based on your own knowledge rather than asking other people to answer the questions for you.

I know this is a little late for the bulk of the discussion, but couldn't you just create a table with one column for the actual date and another in...

Is it faster if a temp variable is used instead of a temp table?

How about if the table was pre-created? The dynamic solutions are still hardcoding values, to be...

You could always mirror for the HA and perhaps log ship on a nightly basis if you have enough of a window and the reporting data doesn't need to be...

Profiler requires alter trace permissions. DTA requires sa rights for the first use, and db owner rights subsequently. These should be sufficient to stop most of your users...

Is there a good reason for using TEXT? It is marked for deprecation.

I don't know about DoubleTake, but I can answer some of your other questions:

1 & 3) From SSMS you can access the Mirroring Monitor by right clicking one of the...

Apparently selecting A is incorrect, because the correct answer is A or B .........

You should probably investigate whether the queries can be optimised to reduce page locking. Also look at whether adding or modifying indexes could help. In this area, I...