Obscure objection.  If there's corruption, you can't restore using your method.  You can't restore to the middle of the rebuild process.  Rebuild is atomic -- it works or...

We differ in opinion only on whether or not using the Bulk Logged or Simple Recovery Model would be a "Pyrrhic victory" victory or not.  I'm simply not...

That's not true, Scott.  The log can be applied.  You just have to use the whole thing.  You can't stop in the middle for a PIT restore.    If something...

Even if the db is not normally in SIMPLE mode, you would certainly want it to be in SIMPLE for these rebuilds, to drastically reduce logging...

Agreed.  I don't even see how to distinguish between a clock-in and a clock-out.

Say you have a 10GB table with 1 clus and 14 nonclus indexes, each with 1 column.  You "tell" SQL to rebuild ALL indexes.  Would SQL scan the...

Excellent point about the CROSS JOIN.  It's much more common than FULL.  Probably want to add CROSS rather than FULL to the q.  Or bring up FULL and/or CROSS in...

No, the specific values are essentially the REPLACE equivalent of a binary search.

The initial code came from someone else.  It performs really well overall, better than other methods, so I...

Say you have a 10GB table with 1 clus and 14 nonclus indexes, each with 1 column.  You "tell" SQL to rebuild ALL indexes.  Would SQL scan the table 15...

Well, yeah, it won't cover everything, but then again nothing will.  It prevents the most common thing where someone just leaves off the WHERE clause.

The SQL internals books are generally very good.  Particularly those by Kalen Delaney.  Sadly the last one was SQL 2012, I think.  I'd pick up a new one by someone...

It's more involved, but you can also create a trigger(s) that insures that a WHERE clause was included on all DELETEs and UPDATEs.  And add an override just in case...

In general you should always review the clustered indexes first, to make sure the single best clus index key(s) was(were) chosen for each table.  In particular, that an identity was...

Many of us don't use SQL Sentry.  Many of us don't use 7zip either.  You might want to use a lower-common-denominator approach to all attachments so that more people can...

I'm curious as to why you left out FULL OUTER JOIN?  I'm...