May 23, 2011 at 4:00 am
What is Service Broker? What is the use of that?
May 23, 2011 at 10:00 am
It's a very robust messaging system inside SQL Server 2005 (and newer).
IT's used to send and receive and process messages in an asynchronous manner.
We have for example used it to maintain a denormalized version of a bunch of our tables. This denormalized table is then full text indexed. To do this we have i trigger in our normalized tables that sends a message to our "denormalizer" service, which then reads necessary data from the database and updates the denormalized table.
The great thing about this solution is that the trigger only has to fire of the message to the target service, which has a positive effect on client response time compared to doing the actual denormalization in the trigger.
Hope this makes sense.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply