Ring buffer for Real-Time data

Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansen
Consider using a partitioned view. When you need to add more data, create a
new table and alter the view. When you want to purge a large chunk alter
the view to exclude the table that has the chunk, then drop the table. The
BOL talks about partitioned views.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Hansen" <ehansen940@.hotmail.com> wrote in message
news:809ff900.0410220459.561bd2f9@.posting.google.c om...
Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansen

Ring buffer for Real-Time data

Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansenConsider using a partitioned view. When you need to add more data, create a
new table and alter the view. When you want to purge a large chunk alter
the view to exclude the table that has the chunk, then drop the table. The
BOL talks about partitioned views.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Hansen" <ehansen940@.hotmail.com> wrote in message
news:809ff900.0410220459.561bd2f9@.posting.google.com...
Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansen