title: I want my database (SQL) to notify or push updates to client application
body: <p>I was developing this application on <code>VB.net 2010</code> and <code>SQL 2008</code>.<br>
  I wanted the clients to be notified for updates on the db, and the application used to check the db for changes in the specified minute using a timer, which really is not efficient. I read about <code>query notification</code>, <code>sqldependency</code>, <code>service broker</code>, but then I read something that said they might not be efficient if I have 100 clients and I'm using query notifications to push notifications to  my application.<br>
  Would someone help out on what I should do, and how I can do it (would be really helpful if examples are available). Thanks in advance!</p>