This isn't very elegant, but it seems to work!

WITH Pivoted AS (
    SELECT
         PAT_ID
    ,    RECORDING_DTM
    ,    CASE
            WHEN RECORD_TYPE = 'BLOOD PRESSURE' THEN...

For schedule changed, see the last line of my first reply.  For job deleted, you need to look for rows with the same job_id that appear in the Deleted virtual...

No "standard" guidelines, no, but here are a few things that I stick to.  There will be exceptions to nearly all of them!

(1) Choose the clustered index key...

Unless it's essential that you be notified immediately upon any change, I think I'd change the trigger so that it writes to a table instead of firing off an e-mail...

Paulo is right.  You don't have any control over the structure of your application database, but if you're creating your own database, don't make the same mistakes with the design. ...

Hemant

You could have answered your own question by using your favourite search engine.  Here is one topic I found - does it help you?

John

Pedro

Replication is still possible with a database in Simple recovery model.  However, I would strongly recommend that you don't use replication from a live environment to a test...

One option is to set up a custom counter in Performance Monitor and then create an alert to send you an e-mail whenever it goes over 80%.

John

You can use a variable in the SYSTEM_TIME AS OF clause, so if you declare and set the value of the variable at the beginning, that should work for you.

How do you know that process is the head blocker?  If it's waiting for a lock then something else must be blocking it.  Do you have sp_whoisactive?

John

What collation are you using?  They both come out as YES for me (SQL Server 2016 SP1, collation Latin1_General_CI_AI)

John