Default ANSI connection settings maybe?

Take a look at the SELECT operator in both plans. Compare every value. What's different?

A million individual insert statements is a horrible approach. Period. Doing it within a single transaction will be painful because you're going to have to have a huge transaction log...

Without the execution plan to look at details, it's hard to know. Recommended indexes are just suggestions. First, I'd take a look at the SELECT operator to see if you're...

You're getting type conversions on a couple of the columns. I'd look to see if that might be causing issues. Also, a Nested Loops join for millions of rows with...

I agree. Constantly learning. I write anyway because someone has to do it. And yeah, the old...

Bhuvnesh (3/8/2013)

Grant,...

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...