Q&A for cartographers, geographers and GIS professionals
select min(create_date) [earliest date (UTC)] , max(create_date) [latest date (UTC)] , getdate() [query run on (UTC)] , coalesce((select name from sys.databases where name like '%_Temp'), 'None') [restoring] , (select string_agg(status,', ') from ( select concat( count(*), ' refreshed ', datediff(d, create_date, getdate()), ' days ago, took ', datediff(n, min(create_date),max(create_date)), ' minutes' ) [Status] from sys.databases where database_id > 5 group by datediff(d, create_date, getdate()) ) data ) [Status of database updates] from sys.databases where database_id > 5 select string_agg(status,', ') [Status of database updates] from ( select concat( count(*), ' refreshed ', datediff(d, create_date, getdate()), ' days ago, took ', datediff(n, min(create_date),max(create_date)), ' minutes' ) [Status] from sys.databases where database_id > 5 group by datediff(d, create_date, getdate()) ) data select * from sys.databases where database_id > 5