Large Tables Performance

Mar 16 at 9:25 AM
I tried to find information of how SqlTableDependency works, particularly does it retrieve all records from a table to be able to track changes. If I want to track changes of 1M rows, does SqlTableDependency retrieves all the rows at start?
Are there any detailed performance results for various situations in real life?
Mar 16 at 9:30 AM

SqlTableDependency create service brkerm queue and trigger (on interested database table).

Every change done on records, the trigger put a message in a queue that is read from SqlTableDependency, reporting you the info about he change.
Mar 17 at 1:55 PM
Thank you for the answer!
My question was motivated because I read about "native" SqlDependency, and as far as I understood, SqlDependency tracks changes on rows retrieved from a database.