>In SQL Server just use CONVERT(char(6), Hit.AddDate, 112) instead of your complex expression. Index on AddDate should speed this query a bit.
>Also, how selective the NoServer column is (e.g. how many values it may have)?

Thanks, NoServer may or may not be in the query. This can have about 1 to 10 different values.