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?

Are you rebuilding the index? A rebuild should result in reduced fragmentation.

BTW, if you're not experiencing lots of scans, it's possible that you don't need to worry that...

It's largely the same. Good code, good structure, proper indexes, statistics up to date, these are what you have to do. The difference is, as you tune the queries, you...