Why do you need DISTINCT when you have TOP 1? TOP 1 is going to ensure only one row gets returned. Eliminating the DISTINCT aggregation could help. I can't see...

where?

Lowell's fix is awesome (as usual).

However, if you do find that you want to run something across all databases, or across all servers, I strongly recommend learning Powershell....

You're going to have to hit the tables and create a manual report (using Reporting Services, PowerBI or something) to pull all that together into a single report. Some of...

Also, in addition to the other suggestion, a very important safety note. If you shrink a database once because of some untoward event, fine. If you're scheduling your shrinks or...

You need an index on Table42 on column application342 with an INCLUDE of application343 and application344.

If that sounds arbitrary, it is. We can't tell you what's wrong with...

Yikes, no keys... You're...

Oh yeah, this is very different. The traditional approach will not work with Azure, at all.

Now, the question I would have is, are we talking about migrating between...

Well, any monitoring tool (and you should look at Redgate SQL Monitor, my employer) is about three different things. First, and I think biggest, it's about time. You're...