See this.  You'll want to order by total_worker_time.

John

Brilliant.  Sample data and update query as well, please.

Thanks
John

If more than one OrderID is updated at once, your trigger will only capture one of them.  Indeed, I think it would return an error.  Please will you provide table...

Yes, a DENY will always override a GRANT, unless the grantee happens to be a sysadmin or (I think) db_owner.

John

Two options:
(1) Do all DML with stored procedures.  Then you don't need to provide permissions on tables or db_datareader/writer access - only EXECUTE on the stored procedures.
(2) Get...

Yes, although if you have a script to generate your log restore statements that won't be too much of an issue unless you have a fairly large and highly transactional...

Yes, I agree with you, although I will say that if your databases are of a size that allows a full backup every night, then I would go for that...

In my opinion, no, it isn't a good solution.  But the answer for you will depend on why you are considering this and what your environment looks like.  Have you...

My guess is that you have a case-sensitive database or server.  You need to type the name of the DMV in lower case.

John

Yes, and if you want to compare queries before and after, you can look at logical reads as well as elapsed time.

John

It's not something I can cover in a forum post, I'm afraid.  You can start here.  Once you have a PowerShell command that works, you can call it...

I don't know.  The best way is to replicate the problem in a different environment and then test.  I'm intrigued by this, so if you post some scripts I'll try...

I wouldn't use the guest user if you don't have to.  The difference between EXECUTE AS and IMPERSONATE, as I understand it, is that the former is a statement, whereas...

Use a script such as the one shown here.

John