How to find how many rows are inserted

[slimdave]

Now there's some advice that sucks.

The point here is that "ALTER INDEX .... REBUILD" is faster than CREATE, since REBUILD uses Fast Full Scan (FFS) and CREATE uses Full Table Scan (FTS).

Rebuild a usable index (without specifying a statistics clause) and the old index will indeed be fast full scanned, but this guy seems to think that applies to unusable indexes, and that his proposed methodology avoids reading the table when creating the index.

What a crock.

Perhaps someone who has signed over all of their personal information to that site in exchange for an id would like to tell the author that he's an idiot.