Hi everyone! This is my first post on this subreddit. I'm absolutely new to the Sql world and I just signed up for a Udemy course to start learning...

Honestly, it sounds like you just need a spreadsheet to rope a few bits & bobs together. I'm with Jeff, focus more on what we're attempting to solve, less on...

Straight up: Extended Events or Query Store. Which set of queries are using the most resources? Answer the question.

It all sounds like pretty traditional query tuning stuff.

You're gathering some metrics, but it doesn't sound like necessarily the right ones. I'd suggest using Query Store or Extended Events to...

Total agreement with all of you. Thanks for the comments.

Not even going to try to sugar coat it.

I'm not a fan of presenting in a 100% virtual environment.

The lack of interaction, feedback, and just the repetitive nature of talking...

With utterly incomplete information, not seeing the query, structures...

Actually we have a database which is not part of availability group and it's reading the data from secondary replica and inserting into the database which is not a...

Take a look at the execution plan. It's going to be all one allocation.

UNION ALL isn't a bad performer in general. In fact, usually, you get better performance with UNION...

Agreed. 5 is too low. You can query the plans in cache to get a sense of the costs. I have a blog post on it.

Literally no magic switch or setting that's going to improve performance most of the time, like Michael says.

In addition to his questions, what is your cost threshold for parallelism. Adjusting...

Capture wait statistics for the individual query. Also, get the execution plan when it's slow and when it's fast and compare the two.

I'd suggest getting performance metrics on individual statements within the query. AND, as has been said several times, the execution plans for the queries. Those two bits of data are...

Hi Jonathan, Thanks for the input. I would like to know if there is any implications/perf issues of using MERGE statement especially when dealing large sets of data?...

Hi Grant Sir,

Thanks for the pointers and sharing the link of capturing Waits. will check with them replace old join syntax's with ANSI joins.

Couple of questions:

1. for conditions like...