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

After the other REPLACEs, you might as well replace all multiple spaces with a single space, to avoid any possible issues with, for example, "  AS  ".   The actual REPLACEs...

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

If the...

• This reply was modified 5 years, 4 months ago by ScottPletcher.

With a table that large, say you have a total of 6 indexes, 1 clus and 5 nonclus.

I'd expect it to be faster to do a REBUILD...

ONLINE rebuilds must be fully logged.  Make sure you have pre-allocated enough log space to handle the ONLINE rebuild before issuing the command.

Then, try an ONLINE rebuild on an index. ...

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

If the db is...

Btw, I suggest not using the term "magical tables" in your interview.  It sounds rather unknowledgeable about relational dbms's.

Oh, virtual tables.  Yeah, SQL has lots of virtual tables.

Yes, you could easily be asked about the inserted and deleted tables.  You can treat these as regular (physical) tables in...