This is a stretch but could it be after your delete that the data is spread all over the disk within the db still so the time it takes to...

There IS a ransomeware thing going around effecting SQL Servers.

https://securityaffairs.co/wordpress/108341/hacking/mrbminer-mssql-miner.html

Thank you for your input.  We decided to go with a new server running 2019.

Oh yes that is the plan.  Identify, communicate to everyone the lists of databases, back them up to a non expiring place, OFFLINE them for 2-3 months then drop them. ...

Lowell.   THANK YOU.   I was overthinking it.  Why didn't I think of your first one for the NOT IN.  But thanks for the second one as well.  That...

Thanks Jeff but that is above my SQL coding abilities.

Yea, that is the problem with this one.  It only lists the dbs since last server restart that have been accessed, I want an opposite list.  In a SQL Server...

That is all fine.  But with some of our servers having 500+ databases on them that is going to be way too hard to interpret the output.  I simply need...

Great query.  Question though.   What is the difference between the date/timestamp for a database of the server restart versus NULL though?

2020-07-17 20:47:46.113 DB_AX_20190724 2020-07-17 20:47:55.650 NULL 2020-07-17 20:47:55.550 NULL

2020-07-17 20:47:46.113 DB_AX2 2020-07-17 20:47:59.580 NULL NULL NULL

If you would drive a Dodge Hellcat Charger, Challenger, or a 700HP Jeep Grand Cherokee you would be shocked how much fun those are to drive.  Any Challenger is a...

Designers hands are tied today.  CAFE standards force designers to make a vehicle go through the wind tunnel with the least amount of drag.  That is why every car and...

This is perfect.  Thank you.

If your 2000 db doesn't have too many tables and data have you considered simply scripting out the tables of 2000 and into 2017 and then select/insert data from 2000...

I am job looking as my position has been eliminated.  The biggest problem I have seen is the job listing does not accurately show what the DBA team really wants...

We just got Cohesity.  I was working with a server engineer on what this means to SQL Server.

I had a TEST SQL Server 2014 that we did some tests on....