Oh boy.

Are there strong opinions on natural keys versus artificial keys?

Yes.

You may get some very strongly worded responses to this question, depending on who sees it and how they respond....

• This reply was modified 6 years, 4 months ago by Grant Fritchey. Reason: typo

Let's, just for a minute, assume that the use of WITH(NOLOCK) was ok to do.  It's stupid to mark every single table with the hint especially if you ever...

Honestly, this sounds like the DBA job of the future. The easily automated stuff, server allocation, SQL Server installs, backups, consistency checks, all these things, should be already automated. The...

PIRATE!!!!

Except Alice says no.

I'd say no. Not the same way as stored procedures. An inline UDF (heck, even a multi-statement UDF) are treated...

Could be, but recreating an index after data changes requires pretty...

BWA-HA-HA-HA-HA!!!!!

Oh, wait. You were serious?

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