Does the list of tables change often? How many tables? You could create a job (SQL Server Agent->Jobs in Management Studio) that executes that...
Does your application frequently update fields that are indexed? That may be contributing to slow response times as well.
Do you have more than 1 week's worth of data in your tables now? If so, you should get the results you are expecting.Is it important to show a full...
How about this? select COUNT(*) [Hits], right(convert(varchar(11),date,113),8) [Month], country [Country], year(date)*100+month(date) [Sort]...
Assuming you're using MSSQL 2005... Check out ROW_NUMBER() in BOL. Specifically, look at the second example.
Separate names with a comma.
