So a little confusion here. Foreign keys should be bound to unique constraints/unique indexes. Now, whether that unique index is a clustered index or a nonclustered index, that's a different...

Another issue that is possible is that you've crossed a threshold on the data or in the statistics that has resulted in a change to the execution plan which is...

And, since you're on 2016, you can take advantage of the query store to force plans. It won't help now, since the upgrade is done, but in the future, the...

It's technically unsupported, but you could use sp_msforeachtable to walk through and do what you want. Here's a link with examples.

Also, if you're doing restores of the databases to non-production environments, you can offload the logical consistency checks to those databases. You then can just do the physical_only checks on...