Stored procs are fine. Great way to exercise MORE control and avoid all the issues we've listed with joining and nesting views. I don't object to using stored procs. I...

Not a comparison I would make. They do different things and will have different uses. Stored procedures...

Same issue on the differentials. If you run a restore and allow recovery, you can't apply a differential.

On the reset, I mean re-restore. To do the log shipping, you can't have recovered the database. It has to be left in recovery. If you already recovered the database,...

Some good info, let me add a couple of more wrinkles.

First, an inline UDF has a nickname, a parameterized view. It's way to set up a query, with parameters, to...

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