Yes.

The only thing losing the witness does is remove the automatic failover ability.

Depends what kind of auditing was set up and how.

If you mean the 'SQL Audit' feature specifically, then https://msdn.microsoft.com/en-us/library/cc280728.aspx, but that's not the only way that login monitoring could be...

Before asking how the entire table gets locked, check and confirm what the exact locks involved are. Next time it happens, look in sys.dm_tran_locks and see what locks exist for...

You are...

It'll do the job, but app names are spoofable.

But the thing is, this is a non-technical problem. Address it as a non-technical problem. Someone is doing something they shouldn't, probably...

Changing the name in one table means that the matching row can't have some completely different attribute changed in another table?

Keep in mind this will cause concurrency problems, may even...

Update locks are held until the end of the transaction, so locks taken for that update already behave the way you want them to.

I've done the second a few times, out of forgetfulness only not malicious intent.

I...

The first wouldn't apply to Celko. Traceflags aren't ansi standard.

Some people, unfortunately, have an elevated opinion of themselves.

Just remove that second restore statement. The gui often does odd things, that's why most people advice restoring via T-SQL.

Ignore, didn't read clearly enough

No, I did not mean to say that....

The...

What's your RESTORE statement?

If you're using the GUI, rather don't. It's a pain for this reason. At best use it to script the restores.

sql-lover (7/20/2016)

---

Does above command will still apply if the new cluster index is different than the original one? Let's say... existing Index is on col1, col2. New one will...

CREATE CLUSTERED INDEX ...

WITH (DROP_EXISTING = ON)

will probably be the least disruptive, but the log impact will not be small (estimate 2x the size of the data), you'll need probably...