Please post here. This is more appropriate for the administration forum. The other post is closed.

The comma typos were corrected and points awarded back.

The current question and answer are correct

Also, please don't stop running dbcc. You need to run these, but I'd do this on another machine. Restore a backup and run this regularly on another machine

Sometimes a rollback will get hung and you need to reboot to clear it.

You want to have an idea of normal DBCC time. If this normally took 4...

Is this homework? Have you actually modeled this in a database system?

You will need a join between your tables. That will be a query such as this for...

We may reach out to some of you. The pipeline and staging systems should be easily setup, so if there's an update, we should be able to apply and test...

I sent a note to the devs. There is supposed to be a new version of the forum software that takes some of our PRs and includes better editing/formatting

You should make note now, if you didn't already, of the issues you encountered and what wasn't available. Or what you didn't have a backup of (a linked server, alogin,...

You (Papil), need to understand how the query works. I'm not sure you do, by your questions. Ask questions about the query, not the result.