Yes. Procedures run in indicated times (roughly 2 seconds and one minute) when run directly from query window. Only when run from job is there additional "delay".

Is there a reason you are not using SQL Server Management Studio to do your database restore? The GUI provides an excellent interface for point in time recovery, automatically listing...

It is the login used by the connection to the instance. Renaming computers with SQL installed can require multiple steps to ensure that SQL is "synched" with the name change.

If you are new to SQL, then read about DISTINCT and WHERE parts of SELECT. Happy learning!

For context, this appears to be referencing the Ola Hallengren utility code.

Yup, I wasn't on the call (IT handled it) but the support response may be because the instance is still on SP1, not SP3 (just guessing on reason).

In any case,...

Thanks! Will check and update on progress. So far I know Microsoft said "troll the internet" because SQL 2008 R2 is no longer supported. We may end up just re-installing,...

Sounds like a rogue scheduled job that has a hard-coded "sa" password. But could be any service that uses that logon and has an old sa password. Could even be...

It is worth noting that if you are using SQL 2016 and above, you can use the built-in STRING_SPLIT function instead of "rolling your own". It is limited to single...

Replicate to data warehouse, need to be backward compatible with older customers using prior versions of software. So COALESCE old key if it exists, otherwise use IDENTITY (actual case uses...

Simply "wrap" your LEFT stuff inside a CASE similar to this:

CASE