SQL Server with Mr. Denny

Mar 21 2008   6:11AM GMT

I had a great time speaking at the San Diego SQL User Group

Denny Cherry Denny Cherry Profile: Denny Cherry


I’d like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my SQL Server Query Tuning and SQL Server Service Broker presentations.  You can grab the slide deck and sample code from those two links.

 I was happy to fill in on short notice for them when there scheduled speak cancelled on them.  Hopefully the members liked the presentations as much as I liked giving them.  Hopefully the San Diego SQL Server User Group will invite me back in the future.


2  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Cr8nk
    Hi Denny, Thanks for the great presentation last night. Just a follow up to the service broker discussion. One of the questions I asked was about balancing creating dialogs vs the amount of messages you send. Just wondering if you have seen this post which talks about the overhead of creating conversations. http://blogs.msdn.com/rogerwolterblog/archive/2006/05/20/602938.aspx
    0 pointsBadges:
  • Denny Cherry
    I hadn't seen this specific post before, and the poster does have some interesting techniques that do appear to need to be looked into more. I would be careful however because keeping the dialog open keeps message information about each message in the system so that the service broker can ensure that the same message isn't send on the same dialog a second time. I could see this having a performance problem and potentially a storage problem depending on how much data is kept around in the database for a received message on an open conversation.
    69,055 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: