I understand your plea but can you at least post an anonymized example of what the output is supposed to look like and maybe even some readily consumable test data...

Agreed.  You do have to know which battles to pick.  We don't actually know how often that query is executed.

Following with a user complain about SQL timeout I bumped into one issue with a view. I ran the Object Execution Statistics report and saw that one particular SP,...

For starters, are you sure that the query highlighted is place to start?

If it's executed once a month as part of a some process, then I would ignore it.

This...

Just like what I would...

8<

We loaded up a lookup table for the different time zones and sub-time zones and purchased some data that lists every NPA/NXX (Area Code...

Now that's funny! 😀

I had to write such a thing because we have to return calls to the customers of our customers.  They cover all U.S./Canadian and their territories...

"How do you get the current date and time using T-SQL question that 20 out of 22 candidates couldn't answer before I stopped counting.  It's NOT a trick...

Heh... allow me to reword that for you my long time friend in arms....

...they need more action based on commonly...

Lynn and David,

Thank you both for the very kind words.  I never expect such replies and I'm seriously humbled by them.

Thank you Jeff for showing the right direction. I always had this issue of generating test data and now I have a plan and your teaching is very helpful....

It calls a view.  We'd need to see the query for that and, again, it would be great to see an "Actual Execution" plan instead of the "Estimated Execution Plan"...

While there is some really good advice out there about the number of files, drives, types of drives, etc, etc, etc related to TempDB, I've found that the biggest problem...

Interesting. It works fine on my machine. When I double click on it it pulls up on my SSMS. It was saved using Plan Exploer if that helps.

I'm attaching...