I think Google has some type of API that does address correcting.

I'd look for that or some other known app to do this.  What you're trying to do is way...

Yeah, we can't anything to improve things without seeing that code.

DECLARE @first_sales_month date = '20200101'
DECLARE @last_sales_month date  = '20201201'

SET @first_sales_month = DATEADD(MONTH, DATEDIFF(MONTH, 0, @first_sales_month, 0)
SET @last_sales_month = DATEADD(MONTH, DATEDIFF(MONTH, 0, @last_sales_month, 0)

SELECT
   ...

I suggest you always explicitly set XACT_ABORT, either ON or OFF.  After that, you just need to understand the implications of  the XACT_ABORT setting.

If it's OFF, you may have parts...

SQL creates a table entry for all db backups.

Look in table "msdb.dbo.backupset" to find the lastest full backup datetime for each db, and link to table "msdb.dbo.backupsetfamily" to find the...

You'd want to make sure PAGE compression was actually appropriate for each specific table first.  In certain cases, page compression doesn't do enough good to make it worth SQL's effort...

Yeah, those scalar ops can be ignored as far as performance goes, as long as they aren't repeated a million times or so.

I would think the subquery would (almost) certainly be able to take advantage of the fact that the query only needs to lookup a single Shipment_No, rather than processing all...

If you don't need the parameters, or they require too much overhead to log, then don't log them.

Just capture the start time, as a datetime2, and the proc name (or...

Thanks for that, now I'm clear.

Yeah, I think the first query you posted should do that.

As to performance, make sure the s and p tables have an index...

Thanks for that, now I'm clear.

Yeah, I think the first query you posted should do that.

As to performance, make sure the s and p tables have an index on Shipment_No...

If I understand your requirements correctly, the code below will do what you want.

As to performance, make sure the s and p tables have an index on Shipment_No...

If I understand your requirements correctly, the code below will do what you want.

As to performance, make sure the s and p tables have an index on Shipment_No and that...

The parms and values where concatenated into...

Add code to the start of the proc to log to table.  While you're at it, you might as well log all the parameter values as...