Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-07 : 11:28:28
|
| Atif Hussain writes "I am Software developer and working for a company that has more than 400,000 records annualy in its MS SQL Server database. Your runningtotal article it better for retrieving the Cumulative(RunningTotal) columns for some thousands rows. But when there are records like 400,000 or more it takes approx 45 minutes or more to extract the entire(400,000) records. Is there any way to retrieve the millions of "RunningTotal" records within few seconds or minutes.Thanks" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-05-08 : 07:04:42
|
| 1. buy a bigger machine!2. increment the running totals...as data is added/deleted/amended within the server....so that the running totals are pre-calculated/saved within the database...(this may be an acceptable solution, if the queries requesting the running-totals don't change throughout the year. |
 |
|
|
|
|
|
How to Speed Up the Cumulative Column