This is kind of an inexact science, but while an update is running, the
rows column will eventually start counting down to match
When these two columns begin getting close to the same value, the update
is almost finished. Run the query multiple times to gauge progress.
select name, rows, rowmodctr from sysindexes with (nolock) where id = object_id('[dbo].[TABLE_NAME]')