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.

I use the ALT trick often.

Hold Shift+ALT and  you can make a vertical selection. by downarrowing. You can type something in there. ALT+Click works with the mouse.

Use the T-SQL. I had time to try this today, and got the same error from the GUI. Apparently there's some bug that the wizard is connecting to the mirror,...