declare @cmd varchar(max) = ' select -9 o union all ' 
select @cmd = @cmd+ ' select count_big(*) as '+name+ ' from '+name + ' with index(1) '
  from sys.tables
  exec ( @cmd )