Top "Query-optimization" questions

For questions about making database queries run faster.

How to get COUNT(*) from one partition of a table in SQL Server 2012?

My table have 7 million records and I do split table in 14 part according to ID, each partition include 5 million record …

sql sql-server-2012 query-optimization data-partitioning table-splitting
Create a ROLLING sum over a period of time in mysql

I have a table with columns date and time_spent. I want to find for each date D the sum …

mysql sql sum query-optimization rolling-computation