If it’s Synchronous Mirroring it should be instantaneous (i.e. no fall behind)

The mirror server immediately writes the incoming log to disk, where it is held until it is applied to...

Congratulations Jeff for ‘Exceptional DBA of 2011’ award.

I recently joined SSC & exploring SQL Server by reading your (& other GURU’s) comments.

Thanks for your valuable contributions. Keep sharing your...

Would you mind trying open source solutions?

DBDesigner 4

http://www.fabforce.net/dbdesigner4/features.php

overlooked the fact 'If DIFFERENTIAL and COPY_ONLY are used together, COPY_ONLY is ignored, and a differential backup is created.'

But differential backup / restore would be single operation on both the...

differential (copy only) backup & restore should also do but you need to schedule jobs on both the servers (same with log shipping).

Factors That Can Delay Log Truncation:

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

Database mirroring requires that each log record remain active until the principal server instance receives notification from the mirror server instance that the...

Just to explain ghanshyam.kundu’s post (table names are creating confusion):

update table1 set table1.col1=table2.col1

from table1 t1 inner join table2 t2 on t1.id=t2.id

table1 – the table you want to update. In your...

I have restricted access to internet (Company's IT policy 😀 ). Would you mind summarizing it for us?

The rebuild operation can be minimally logged if the database recovery model is set to either bulk-logged or simple.

Choosing a Recovery Model for Index Operations:

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

If the files are set to grow automatically, then “Yes”.

Per MSDN:

If a backup operation overlaps with a file-management operation or shrink operation, a conflict occurs. Regardless of which of the...

Nice article indeed.

I prefer manual file management than auto-management (auto-grow, auto-shrink, defrag etc.). The reason is simple ‘I (as DBA) know better when the database must grow / shrink’.

1)I'm using .net - is there a way I can configure schema name as a part of connection string.

Dev:: I am not sure on this but if you have separate...

If the data volume is huge, UNION will certainly kill the performance.

The solution in the practice exam is correct.

I am sorry for my previous post (I corrected it). Please go through following MSDN article.

Designing Partitions to Manage Subsets of Data: