Exactly.

Moreover, you don't even have to have a login for [DomainA\GroupA] in the server.

Users such as [DomainA\GroupA] can be created in a database without a mapping login, but they...

I'm assuming a lot of things here that you did not say.

1) I'm assuming MachineID is the primary key of all your tables

2) I'm assuming you already have some data...

An exception is windows groups existing as users in databases and members of the group existing as logins in the server. In this case user and login won't match, but...

Hi and welcome to the forums.

Which one is the target table? Test1? Test2?

Please post table scripts, sample data in a consumable format and the expected results.

Guidelines here: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

LogShipping does not replicate server level objects such as logins, so your user will be unable to log in to the secondary server when you switch roles.

You can migrate existing...

This is a great place to start:

https://blogs.msdn.microsoft.com/sql_protocols/2008/04/30/steps-to-troubleshoot-sql-connectivity-issues/

DBCC is a disk-intensive operation. I suspect that the database becomes unresponsive due to resource contention rather than "locking up".

Try investigating blocking (set up an extended events session for the...

Log records are written first in memory and then to disk.

Every RDBMS uses WAL (Write-Ahead-Logging) to ensure consistency, so every operation that generates log records is said to be...

As far as I can remember, it has always been like that. At least from 2005.

You can reproduce the behaviour easily:

1. Create a windows group 'testGroup' in lusrmgr.msc

2. Create a...

This seems to be slightly snappier:

SELECT Id, CASE WHEN MIN(Ranks) OVER(PARTITION BY ID) <> MAX(Ranks) OVER(PARTITION BY ID) THEN 'XXXX' ELSE Code END

FROM (

SELECT

DENSE_RANK() OVER(Partition By ID ORDER BY ID,code)...

Please post data in a consumable way. See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidelines.

How do you calculate the ranks? Please clarify.

If you're on Enterprise Edition, you can use an audit to detect trigger enable/disable events: http://solutioncenter.apexsql.com/how-to-audit-your-auditing-in-sql-server-tracking-when-triggers-are-disabled/

No magic at all. All I do is dump this...

SELECT *

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS p

... to a a file with BCP.

Than I BCP in the file to my local...

It's a great way to start a love letter.

Please, go ahead 🙂

Just joking, don't take offense. 🙂

If you hit "post" too early, you can go back and edit your post.

Actually, I never perform cache analysis in production.

I usually dump the whole cache to a table in my local sql server and start from there.