Create a job which runs every 5 seconds and KILL the processes of specific user(s) where program_name is 'Microsoft SQL Server Management Studio - Query' and that reached specified threshold,...

SELECT name, log_reuse_wait_desc FROM sys.databases?

The original question is totally wrong. Who cares why the query plan is different on these 2 servers or if one server has more memory or if there is a...

I'm not sure that it would help, but try to add condition "tgt_roi.fkRevPeriod = @fkRevPeriod" into ON clause, like this:

ON tgt_roi.fkOrderItem = src_oi.fkOrderItem AND tgt_roi.fkRevPeriod = src_oi.fkRevPeriod AND tgt_roi.fkOrder =...

/*COMMENT!*/

43697

Nothing is truncated. Accept it. The stored procedure has 43696 characters.

If it's the same, then what's the point?

Are you sure?

SELECT LEN(definition) FROM sys.sql_modules WHERE object_id = object_id('procA')

Use system_health event session to get deadlock graphs.

SELECT [ObjectName], LEN([TSQLCommand]) FROM [dbo].[tblStoredProcedureAudit] ?

If users can access database then they can modify it. So,...

It could be a limitation of SSMS.

Don't need to run a trace, simply use the default one (if enabled). Then you can get ApplicationName and ProcessID.

Use this query:

DECLARE @filename VARCHAR(500)

SELECT @filename = SUBSTRING(path, 0,LEN(path)

...

You should have asked that question when your transaction was...

Generally, there is no issue of loading 1.5 million records to a temp table.

But in your case, you didn't provide enough information to argue on the question. 1.5 million records...