Posted by paulb on 11/29/06 07:37

Erland,

Query Notifications look like they would do the job alright but it
would mean writing each new piece of data to a table, querying it, and
then pulling the result back into my program. If this is the only
solution then I would probably be better dealing with the data-stream
within the program as speed is a huge factor and recording the data is
a secondary concern. My main question was whether there is specific
functionality within SQL Server to deal with real time analysis of data
streams?

Thanks,

Paul.





Erland Sommarskog wrote:

> paulb (paulbermingham@gmail.com) writes:
> > I was wondering if it is possible to continuously query a real-time
> > datastream using SQL Server. Does anyone have any experience of this? I
> > have found LINUX based systems such as Borealis and STREAM. I would
> > prefer to use a Windows based system as the program using the query
> > results is Windows based.
>
> What more exactly what you want to achieve? Query notification is the first
> thing that comes to mind, but it may not be exactly what you are looking
> for.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]