I am working with a legacy database that has implemented query notifications against a table called ColorList.
While running a server-side trace for an unrelated issue, I noticed the query
SELECT color FROM ColorList
was being executed every 10 milliseconds.
Is this how Query Notification works? Does SQL Server store the results of the original query and then run the query endlessly until it detects a change?