Service Broker

  • Comments posted to this topic are about the item Service Broker

  • Nice question. And easy, if you ever studied for the certification exams.

    Thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks, this is easy one 🙂

    M&M

  • Service Boker? 😀

  • I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here use it? What are some real world uses for it and why is it better than other alternatives?

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

  • Good question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • There should have been a fifth choice.

    "Ring the DBA and tell him you wand Service Broker enabled"

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Nice question again Steve.

    I like the ones that help everybody learn and study for thier exams at the same time.

    I alos noticed that the BOL How To help index does not return any results when you search for this.

  • toddasd (4/21/2011)


    I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here use it? What are some real world uses for it and why is it better than other alternatives?

    We tested it's use to replace our Business Layer remoting services. We found that our nTier application having seperate windows services running the Business layer code before the DB connectivity improved performance so we dropped it.

  • Nice and easy one...Thanks Steve.

  • toddasd (4/21/2011)


    I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here use it? What are some real world uses for it and why is it better than other alternatives?

    Yes. I tend to leverage the heck out of it. It's excellent for parsing eventual data to other servers (instead of linked server triggers to move the data, use broker). I also use it to deal with large batches that come in as smaller pieces (one message at a time), allowing heavily abused systems to not get locked up in the middle of the day when someone finally gets a load in.

    It's a messaging service, like MS Queue. All the reasons to use MS Queue apply to Broker.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • nice easy question; but rather boring. How do 38% get this wrong?

    Tom

  • Tom.Thomson (4/21/2011)


    nice easy question; but rather boring. How do 38% get this wrong?

    I assume because a lot of folks are like me and instead of researching, then answering, they answer, then research to fill gaps. My score's an honest one, I rarely do pre-research. It also means I miss some of the incredibly easy stuff because I assumed I knew it and didn't.

    This one in particular I got right, however.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Craig Farrell (4/21/2011)


    Tom.Thomson (4/21/2011)


    nice easy question; but rather boring. How do 38% get this wrong?

    I assume because a lot of folks are like me and instead of researching, then answering, they answer, then research to fill gaps. My score's an honest one, I rarely do pre-research. It also means I miss some of the incredibly easy stuff because I assumed I knew it and didn't.

    This one in particular I got right, however.

    This one I could answer because I had read about it a long time ago (not sure exactly when, but certainly before May 2009). I'm just surprised that 38% of people haven't done that reading, I guess.

    If I don't think I know the answer, don't think I can deduce the answer from things I do know, can't get an answer from my mental model of the way MS does things, and don't have a gut feel for the answer then I might start to do some research or I might just answer at random to see the answer the easy way. For the 5% (that's a guess, not a measure) of questions for which I do start to research I rarely find an answer quickly (and an answer I find quickly is sometimes the wrong answer - there are misleading things in MSDN, although it's a lot better than most technical websites); much of MSDN (including much of BoL) is organised as teaching / expository material not as reference material, so research can sometimes entail masses of reading and if I don't have time (or don't feel like reading a lot) I sometimes give up after a while and make a guess (a better informed guess than if I hadn't started, of course, but a guess nevertheless).

    If I were being paid to work on something and wasn't reasonably confident that I had the right end of the stick, it would be irresponsible not to do at least some research (of course that includes "suck it and see" as a research method when the cost is low enough); so I ask myself whether I would suck it and see or dive for MSDN if the question came up when I was working and let that tell me whether to guess blind or start researching. Of course I apply a lower confidence requirement for QotD than I would for work, as well (and that definitely increases my wrong answer rate).

    edit: spelling

    Tom

  • Thanks for the question. I just learned about Service Broker using MSDN Link : http://msdn.microsoft.com/en-us/library/ms345108(v=sql.90).aspx

    -----------------
    Gobikannan

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply