Return to Question

This stored procedure runs every 2 seconds using the trick I learned from this dba.stackexchange.com post.

This stored procedure runs every 2 seconds using the trick I learned from this dba.stackexchange.com post.

I have taken an execution plan that I've attached below. This execution plan is one iteration of a staging table -- 100k records. The execution of the query was fairly quick, around 2 seconds, but keep in mind that this is without indexes on the SignalValues table and the SignalValues table, the target of the INSERT, has no records in it.