Yes, a standard Agent Alert, like below, but you need to change <instance name> to your actual instance name and the job id to your actual job id:

            
April 9, 2021 at 8:41 pm
            
#3867407

            
            
                                                
        

Overhead.  The default health trace contains deadlock info, although I prefer to create my own extended event specifically for deadlocks.

I have an alert that triggers a job when a deadlock...

There is a T-SQL forum.  This type of q would generally go there.  But not a real problem.  Try the code below:

SELECT pf.Name, 
   ...

on...

(1) Yes.

(2) It means to any recoverable resource, that is, any resource affected by COMMIT / ROLLBACK.

(3) Data in memory (in a buffer) that is forcibly written to disk is...

First, need to number these qs:

(1) With WAL - Any modifications are written to the transaction log before they're written to the data files (mdf). Is this correct?

Most articles...

I'm not getting any syntax errors on:

ALTER DATABASE [IBMStemplate] SET ANSI_NULL_DEFAULT OFF

Not sure what that's about.

Btw, I just noticed that you're growing the log file by 10%.  NEVER use %,...

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd894051(v=sql.100)

"

Compressed pages are persisted as compressed on disk and stay compressed when read into memory. Data is decompressed (not the entire page, but only the data values of interest) when...

We have dedicated Sr. People for optimization and they have been doing it for more than a decade for some good clients. So we trust their...

SQL often "parses ahead" for errors.  SQL detects that the db doesn't yet exist and so can issue errors.

I usually use dynamic SQL to get around these types of errors:

Since we have NO previous knowledge of your tables and how they're used, we need specifics to make any reasonable judgements.  It's rather frustrating when we ask such things to...

We have dedicated Sr. People for optimization and they have been doing it for more than a decade for some good clients. So we trust their understanding for...

That's correct.  You don't even need to include Operations.OpOrder in the SELECT results and you can still ORDER BY it.

In general, you can exec the proc that way.

However, since that proc does absolutely nothing, you'd be better just removing all the code that execs it.

I still have my doubts on the clus index keys.  But you could be right.

By the way, are most of the tables clustered on an IDENTITY column?  If so, you...