I should have said "7 pm ANY DAY this week".

We have a similar plan to what you propose, as our standard for about 60 servers, varying in size from 1/2 GB to 128 GB.

Sun 7:00 pm - Full backup...

I'm a relative noob myself, but I have half a dozen clusters. They all have in common that the data drives, log drives, quorum drives, etc. are shared by the...

Before I resort to restoring a backup, I would first attempt

DBCC CHECKDB

with the assorted repair options (REPAIR_FAST, REPAIR_REBUILD, and REPAIR_ALLOW_DATA_LOSS). Only if these failed would I restore from backup. 

What's legal? See above (sounds about right).

What's moral? IMHO:

He/she agreed to purchase two for the price of one. When Amazon shipped the two, it fulfilled its part of the contract....

Apologies, Sergiy - I hadn't yet noticed that there was a second page when I posted. Ours are functionally identical.

How about:

WHERE name like '%bnb%'

and id = 100

AND ( CASE @custom_value

        WHEN 'D' THEN AL1.amount

        ELSE AL1.quantity

      END) between @threshold_value1 and @threshold_value2

"what are the disadvantages of using dynamic sql in stored procedure over your specified approach ( I really didn't get it properly) "

You are sacrificing the significant performance advantages of...

SA is disabled when you remove Mixed-Mode authentication (selecting "Windows Authentication Only").

You'll complete the task quickest by using your first method,

insert into tablename select * from tablename

If this affects your user base unacceptably, schedule the job when users...

I don't know if this is strictly relevant, but several of our SQL installations are using three nodes, albeit they are active-passive-passive. The server guys who set them up said...

Assuming that X and Y are the PK, I would use the following variation on the common "not-in" query

insert into dest(x,y,a)

select source.x,source.y,source.a

from source

left outer join dest on...

Excellent explanations. I appreciate that English is not his first language; however his knowledge of the topic and exhaustive examples provide a much clearer lesson than I have been able...