Contest Entry:

For query 1

I would put an index on Time and Data for the analysis log table.

For query 2

The query 1 item would take care of this query as...

This article misses the fact that the tables will most likely be referenced by other tables. For instance, I have started working for a company where they didn't do...

There are times to use them. I'm jaded because I work on a product where a lot of C developers wrote the database originally. There is dynamic sql...

You don't have to use a cursor to concatenate a string.

DECLARE @myVar varchar(MAX)

SET @myVar = ''

SELECT @myVar = @myVar + mycolumn + ' '

FROM myTable

SELECT @myVar