Short circuit count query
Is it possible to stop counting after, say, one hundred rows so that I can simply display "100+" for the row count?


Sure.  A query like this should do the trick:

with q as
(
  select top 100 *
  from …
  where …
) 
select count(*) 
from q