This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things...

This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things the way we...

erm…. I picked up on one word - "weekend"

so is there any possibility that it's a rebuild index with "Sort in tempdb" option enabled... we all know which jobs...

Sounds like you're probably OK. Update the statistics after a data load like this.

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...