Short answer, yes.

Longer answer, Microsoft publishes some of the internals because it helps people understand how or why things are...

Not arguing, just clarifying, won't it allocate some...

I sure wouldn't turn on both. In fact, I'd suggest just using 1222, not 1204.

How about taking a look at the system_health extended event session. It automatically captures full deadlock...

I don't have a document I can share with you. Sorry. Maybe something I need to write up.

The maintenance that is available to you with Azure SQL Databases is limited...

In general, if I'm going to have to fix it, I want control over it. It's that simple. They're trying to give you the responsibility without giving you the authority....

That's an extremely open-ended question. The problem is, the daily duties vary from one organization to the next. Further, they vary from one group within the organization to the next....

I'll be perfectly honest, I don't understand most of what you're trying to describe.

From the description, you've wondered extremely far afield of traditional relational storage. As soon as you...

The query engine will do what it does. That's in the internals. No way to know without a debugger or insider knowledge. It will use tempdb though.

And you really can't use those costs to compare one query to another because of what everyone else has said. Within a given query, you have to use the costs...

Estimated IO cost is only partly based on page count. But, the fact that you're getting discrepancies is the beginning of what might be the issue. Have you looked at...

I've got a poster over at AskSSC that is utterly confusing me. He's either very unclear, or I'm very obtuse or some combination of the two. If anyone with an...

Instead of opening it up within the GUI, just run a query directly against it using sys.fn_xe_file_target_read_file

The best resources to learn about internals are the Books Online and the book SQL Server Internals by Kalen Delaney, et al. Benjamin Nevarez book is also a pretty good...

Refer back to the number of pages in the indexes. You can use sys.dm_db_index_physical_stats (I think that's right, typing from memory) to see the size of the index or table.

Just remember that simply adding files won't always speed things up. It's adding files with additional disks under them that really makes a major difference. But, then you have to...