Home Forums SQL Server 2012 SQL 2012 - General Is there a fast way for SQL to do a Group By Count on items within a group? RE: Is there a fast way for SQL to do a Group By Count on items within a group?

  • May 2, 2014 at 2:03 pm

    #1710452

    Is it better to do this with SQL or C# ?

    I have the table running in memory via C# and the initial load takes 52 seconds, then each count, as a test all cities in CA, takes 0.03 seconds.

    Thanks