I was just troubleshooting a similar issue to find the difference was the default database assigned to the user accounts.  After getting query execution plans for both logins (which...

Yes. You will be hard pressed to find join in any EF tutorials; other than just the places...

PREACH BROTHER!

Writing the final chapter of the book, and the first section...

Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...

@Grant ,

Awesome... I don't know...

@Grant ,

Awesome... I don't know how...

Thanks for all the feedback everyone. Appreciated.

Me, I love tuning queries.

Yes Jeff, working on the new book. Chapter 20 right now, Graph data.

Have fun with the baseball. Most fun I've had is going to the games with Allen White. I like watching him watch the game. Far more fun than the game...

Thanks Rick, but I'm not actually going to Gettysburg this trip. Sorry for the confusion. This time it's Pea Ridge and Vicksburg.

Uh oh. All the shame.

Thanks Steve.

Appreciate it Luther. I plan to hit the Virginia battlefields someday.

Tom, not sure, but I had a blast tromping around the Gettysburg battlefield with the...

Yep. Pretty much.

Ha!

The optimizer will absolutely rearrange your WHERE clause. It's part of how it works. It'll also rearrange and reorder your JOINs. So, from the most simplistic approach, WHERE & JOIN...

Just piling on with @ratbak

Every object in your queries should be qualified with the schema owner. If for no other reason, it reduces, in ever so tiny an amount, the...

Thanks everyone for the feedback so far. All jives with my understanding. I've just never heard the phrase "healthy deadlocks" before, so I was curious what others thought.

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement:

Some deadlocks are healthy.

or

Some level of deadlocks is healthy.

Or is more something like:

Some level...