It is an interesting question. I suppose if there were zero data changes, you probably could just restore the index in a piecemeal restore if it's on a different file...

As you've defined it, can you just capture the delta? No.

Instead, you have to look at additional processes or methods to arrive at this. For modern servers, I recommend looking...

If you're rebuilding all the indexes, stats are not a worry. However, since you're doing a bunch of partial updates, I'd be a bit more concerned that simply enabling indexes...

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