Using SQL Cache Dependency
Subject:   Why use polling method if query notifications can be used?
Date:   2008-04-02 07:18:29
From:   Skyfish
If you're using SQL Server 2005 and .NET 2.0 you might as well use the query notification method instead of the one described here. The polling method hits the database every N milliseconds (impractical) while the query notification method does not. The query notification method is based off the push model instead of the pull model. Since SQL will notify .NET when the query has changed this has better performance gains.