The table has about 5.5 million rows, and if it helps, the properties of the table specify 555MB of data space and 200MB of index space. I don't know...

Yes, that is the idea. I think this is similar to your idea:

declare @dtCurrent datetime

declare @iTotal int

select @dtCurrent='10/15/2007 12:00'

while (@dtCurrent < '10/15/2007 13:00')

begin

select @iTotal=count(ID)

from Sessions

where @dtCurrent between StartTime and...

That is pretty much what I want to do. but in your example, the @pointInTime will be every second for a given interval. For example, on the web-front end...

What are some methods of getting data from the OLTP instance to the OLAP instance?  Triggers or scheduled stored procs?  Is there anything within SQL Server (some type of replication)...