get number of events per day from profiler trace
Try: 

GROUP BY cast(StartTime as DATE)
ORDER BY cast(StartTime as DATE);


Grouping by the raw, unconverted value means you are guaranteed to have a row for every unique StartTime. (And it probably makes sense to sort that way, otherwise your rows could come back in an arbitrary and unintuitive order.)