This is flat out a coding and design issue. The code could be simply bad. Or, it could be doing things that aren't using the appropriate data structures, indexes, etc.....

Sub queries come in several stripes. Correlated sub-queries (which I shy away from)

SELECT

(SELECT b.cola FROM tableb AS b

WHERE b.ID = a.id)

FROM tablea AS a

WHERE a.otherid = 42;

Or, as a table...

Create specific logins as owners for the databases. Just as in the other question you asked, least privilege principle should always apply. Setting 'sa' as owner potentially opens things up...

Agreed with @NorthernSoul.

If you mean how do you set up administrator privileges, I'd suggest that each instance has a different login than the underlying OS. Least privilege principle should...

Isn’t it a kinda shame to have such queries exposed on a specialised site of SQL Server professionals?

Could we form a group of volunteers who could fix this...

I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...

Just gotta find a volunteer to do the organizing and...

Whoa! That sure reads like a bit of a mess. I hope they can straighten it out. I can't say I'm a fan of SE, but I'm not actively opposed...

What the heck is a FULLZ? Are dead FULLZ better than live FULLZ? Inquiring minds.

Even if we do a virtual SQLSaturday, I'm positive the local events would continue. While a lot of people want to have big events with a host of international speakers,...

PASS hosts a whole bunch of different virtual events year round, 24 Hours of PASS and the PASS Marathons. Plus there are the virtual chapters that meet...

Hopefully today was better.  That last one is one of my big fears, loosing my keys, along with loosing phone or wallet.  Had something similar happen to a friend...

Don't forget about statistics. The reason to do an index rebuild is, in theory, to reduce fragmentation. However, as a side benefit, you get rebuilt statistics. It's entirely possible that,...

All it takes is one person within your company who is authorized, let's say to see the credit card data, but not the PII of individuals, accidentally, not even on...

I don't have an answer to your question, but please let me point out another issue.

You're getting ready to hop the 2014 Cardinality Estimation Engine upgrade gap. The new CE...