That's rite.. and all your suggestions are very valuable.

Thanks

This is well fabricated one, I am doing something very similar thing RBAC remediation and I am stuck at place where user defined roles got what access , I mean...

Refer to the link .. might be helpful understanding the @query parameter and alternative.

http://www.sqlservercentral.com/Forums/Topic1004043-338-1.aspx

well , in that case why not using backup and restore ... backup to multiple files and restore ... and make it a schedule in or package SSIS.

well... thats for basic understanding.

There are couple of ways doing this , you can use Replication or regular backup and restore. With regular backup and restore method take the backup into multiple files either...

Yes, Well you can use RECOMPILE or OPTIMIZE FOR / PLAN GUIDES query hints ... i never used these but below links helps to understand.

https://msdn.microsoft.com/en-us/library/ms190417.aspx

https://msdn.microsoft.com/en-us/library/hh213001.aspx

basically syntax used is

exec <stored...

Why not using Always ON since you already using 2012. secondaries can be used for reporting with out any changes.

I Believe you are talking about two things here , Event Notification Vs Extended Events which is a new feature in 2012 where is no mail alerting mechanism embedded and...

Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.

follow the link

https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx

You need to modify the table Event Data , Add MC.CompA values if you want to filter depending on CompA values or if you need to select by CompB values...

Silly way is disable all constrains and dump the data.

What is the current transaction isolation ?

Try to use this code to get the error messages

CREATE PROC [sys].[sp_readerrorlog](

@p1 INT = 0,

@p2 ...

Dell Porducts,

Spot Lite GUI mode but good for understanding and alerting ..

And Foglite i used it every ware but it takes little effort understanding the alerts and configuring but its...