The driver has to be the leading edge and then subsequent columns. Also look for ones that are unique and non-unique but have the same columns. Always go for keeping...

Exec plans at least to try to answer this.

Thanks. Just trying to...

That's not available in Azure SQL Database because you're not dealing with a server, which uses default trace to generate the report. Instead you're dealing with a database as a...

Intellisense works fine as long as you only ever use SQL Prompt.

You can run Extended Events to capture this type of behavior. If you want to schedule a script to run, you can do that through Azure Automation.

You can't change that setting in Azure SQL Database currently. You can use Database Scoped Configuration to control the MAXDOP, but I'm not a fan of this approach.

Generally you just write the delete script for the children and then for the parent. there's no magic here.

It's all about understanding what you're doing well enough to educate people. If they have a query that is SELECT * FROM Table and it returns 20 terabytes of data...

Instead of using an IN clause, use another JOIN to retrieve that data. You would have to build a dynamic statement to perform a count before you tried to JOIN,...

It's always tough to make any kind of recommendation on stuff like this. Every situation has unique aspects that my affect what you do and how you do it. However,...

If you've done a rebuild, it shouldn't be fragmented any more. What command are you using to do that rebuild?