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 - 2002-03-13 : 08:48:12
|
| Jane writes "A software program has been produced that displays a line graph on the screen with points that have been stored in a database at 30 second intervals. On Screen, the requirement is to display sample points with +-5% precision at 30 second intervals over 240 pixels (2 hours) and allow scrolling back to the first point N days/weeks/years ago to the most recent point. Additional points are continually stored by date/time in the database on an on-going basis and the storage requirements are exceeding maximum limits. The data is stored in a single database table in MS SQL Server by a keyed field "POINT_DATE_TIME" (date/time of occurance) and a floating point field "POINT_VALUE" (point value at the date time). What methods could you provide to reduce the storage requirement of this data over time?" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-13 : 08:48:12
|
| This just really reads like a home work question. Is this homework? |
 |
|
|
|
|
|
How to reduce the storage requirement