Can this query be improved? view for few count totals on a table
Use CASE so that only one full scan is needed. An non-clustered index on iscomplete will cover this query.

SELECT
      COUNT(1) AS Total
    , SUM(CASE WHEN iscomplete is null or iscomplete = 0 THEN 1 ELSE 0 END) AS Active
    , SUM(CASE WHEN iscomplete = 1 THEN 1 ELSE 0 END) AS Complete
FROM dbo.alerts;