what security context did you use when you created the linked server?

This is what my test uses. The account is dbo in my case.

btw I prefer...

sys.dm_io_virtual_file_stats returns data since last startup of SQLServer.

To get what you aim for, you should persist its data yourself.

By itself that data means nothing at all.

It's only use is...

I suspect this may be an OP spam post ....

What are you trying to accomplish?

Why should a UDF be able to handle that?

Check "Valid statements in a function"

Here is what I use:

-- Deadlock information analysis
Declare @Debug bit 
Set @Debug = 1 
Set @Debug = 0

Declare @waitresource varchar(128) 
set @waitresource = 'KEY: 7:72057600361103360 (97e5c9409bc8)'
set @waitresource...

your varchar(4000) consumes as much space as your varchar(19) !

That's the whole point of data type varchar !

Do NOT store date/time/datetime date in (var)char columns !

Always use the correct data...

We only create full backups (some daily, some every 3 days, some weekly) and log backups.

Most of our databases are small, but have a fair amount of I/U/D transactions.

We do...

Lets practice some relational stuff, now your sets are small

visualize what you are doing !

Moving the year selection to a view is going to...

I haven't experienced any issues just performing the upgrade on passive nodes.

The upgrade process handled it all very well.

Because you use "AND races.race_year = 2019" you turn your query result into the results of an inner join !!

add "or races.race_year is null" if you want the full results

BTW:...

It's always lovely to have numbers, dates , datetime info stored in (N)varchar as it guarantees for problems in the future.

Is there any chance you can just replace the '$'...

I haven't got a clue

because I don't like sequence numbers in column names ...

Declare @pvtColumns nvarchar(max) = ''
Select @pvtColumns= stuff(
   (
        ...

With the answers you provided, DRP = worst case, how much data do you think you will loose ? At least 24h !

and how long will it take to get...

1. Why only systemdbs once a week ??

You will lose a week of systems administration actions, sqlagent job information, ...

2. What kind of SQL instance is this? DWH / OLTP...