I have to admit that I miss in-person events because, as good as they can be, discussions even on things like teams still don't have the "feel" and "serendipity"...

While just moving from Standard to Enterprise can result in differences in execution plans, you may also be seeing other things. Check the server settings. Stuff like: default ANSI connection...

Depending on the amount of data in the master data, I've done this all with scripts in source control. That assumes the master data is all just lookup information, 5...

I suppose if you have really good monitoring in place, you could use this approach everywhere. However, what I've found over the years is that some databases need a limit...

Thanks Rod. Yeah, you've hit the nail on the head. While I found the hybrid model put together by the conference to work pretty well. It still didn't get the...

Source control here will be your buddy. First, like Phil says, make darned sure every query is using the schema as a part of the query (honestly, this should be...

If you use the event auto_stats in Extended Events, you get the specific reason for the statistics update. This will let you differentiate between whatever is occurring automatically and...

Multi-Statement, Table Valued, User Defined Functions have a very useful acronym that is worth remembering:

EVIL

Yes, I know it doesn't match MSTVUDF. Doesn't mean I'm wrong.

A couple of points on this.

First, in the suggested solutions, you left off the schema from the tables. Always include the schema in tables referenced in the FROM criteria. It...

Good gosh, that's not a short list. You have DISTINCT and TOP in the SELECT list. ON in the JOIN criteria, plus APPLY, PIVOT and UNPIVOT. WHERE of course including...

You'll need to explain that in detail to my knees. Ha!

However, yeah, total agreement.

To understand what's happening, I'd suggest capturing some metrics.

First, query performance metrics. You're posting in the SQL Server 2012 forum. Assuming that's what you're running, the best tool for the...

Here is a little challenge.

Look back at 10, 15 years of new feature in or around SQL Server you've learned or heard about.

What share of those features did...

Yeah, and there are also a ton of checks built into DBATools. So that might be worth looking at. There are also 3rd party solutions. For example, my company,...

A quick note on why creating a clustered index first and then loading the data is usually the best approach (testing is always your best friend). The clustered index defines...