Why Service Broker? + Service Broker customization
First, let’s start from advantages of Service Broker (SB) – why it can be useful. I will list main points and examples how we use it. SB provides mechanism of asynchronous queue. This gives us an opportunity to move some hard SQL procedures from users’ transactions. E.g.: we had stored…
