Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 11,311 through 11,325 (of 66,712 total)

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

tosscrosby SSCoach Points: 18045 More actions · Answer 1

Roy Ernest (2/10/2010)
TI am sure the OP will change his ways from thinking Cursors are fast...:-) The OP will probably see the light at the end of the tunnel..:-)

Whatever Roy is having, I want some! 😉

-- You can't be late until you show up.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

I really need to get into doing SB and event notifications - that looks like a lot of fun. 😎

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

CirquedeSQLeil (2/10/2010)
Barry is in a smackdown mood today. That's two on the day.

Yeah, there's just something about feeling like I have a screwdriver jammed up my spine that makes me cranky.

Sorry folks... 🙁

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

RBarryYoung (2/10/2010)
CirquedeSQLeil (2/10/2010)
Barry is in a smackdown mood today. That's two on the day.
Yeah, there's just something about feeling like I have a screwdriver jammed up my spine that makes me cranky.
Sorry folks... 🙁

Hmm, I just reviewed my posts for today, I think I have to post some apologies...:blush:

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Barry,

That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

OK, here's the first one:

Lynn:

I want to apologize for what I said about you in the "black-list" thread. I know that it wasn't derogatory, but it was condescending of you and your position in the communities on-going "bad behavior" discussion over the past year. I was trying too hard to make my point to that fellow and I did not fairly represent your position, I'm sorry.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS it runs correctly?

At this point I'm just looking for tips. If I find myself hitting the wall too many times, I'll come back with more details.

Using SQL Server 2008 Enterprise Edition if that helps with the tips.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

Lynn Pettis (2/10/2010)
Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS it runs correctly?
At this point I'm just looking for tips. If I find myself hitting the wall too many times, I'll come back with more details.
Using SQL Server 2008 Enterprise Edition if that helps with the tips.

Yep, two tips

1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker project". It's actually got 15 tips in it, so it's more of a mega-tip.

2) The symptom that you are describing is most often caused by the restricted security context that the Activation Procedure runs under. In particular it typically cannot access non-public resources in other databases without some special setup.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

RBarryYoung (2/10/2010)
Lynn Pettis (2/10/2010)
Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS it runs correctly?
At this point I'm just looking for tips. If I find myself hitting the wall too many times, I'll come back with more details.
Using SQL Server 2008 Enterprise Edition if that helps with the tips.
Yep, two tips
1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker project". It's actually got 15 tips in it, so it's more of a mega-tip.
2) The symptom that you are describing is most often caused by the restricted security context that the Activation Procedure runs under. In particular it typically cannot access non-public resources in other databases without some special setup.

Thank you, Barry. I will look at those this evening while Kylie is at church and I'm sitting at McD's.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 10

Steve Jones - Editor (2/10/2010)
Barry,
That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.

which one was that? I can't seem to find it.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 11

Lynn Pettis (2/10/2010)
RBarryYoung (2/10/2010)
Lynn Pettis (2/10/2010)
Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS it runs correctly?
At this point I'm just looking for tips. If I find myself hitting the wall too many times, I'll come back with more details.
Using SQL Server 2008 Enterprise Edition if that helps with the tips.
Yep, two tips
1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker project". It's actually got 15 tips in it, so it's more of a mega-tip.
2) The symptom that you are describing is most often caused by the restricted security context that the Activation Procedure runs under. In particular it typically cannot access non-public resources in other databases without some special setup.
Thank you, Barry. I will look at those this evening while Kylie is at church and I'm sitting at McD's.

Heh. Poor guy. Both of those places are better than having to read some junk that I wrote. 😀

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

RBarryYoung (2/10/2010)
Steve Jones - Editor (2/10/2010)
Barry,
That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.
which one was that? I can't seem to find it.

Replacing the handshake with slapping the back of the head. Can't remember what company though.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

RBarryYoung (2/10/2010)
RBarryYoung (2/10/2010)
CirquedeSQLeil (2/10/2010)
Barry is in a smackdown mood today. That's two on the day.
Yeah, there's just something about feeling like I have a screwdriver jammed up my spine that makes me cranky.
Sorry folks... 🙁
Hmm, I just reviewed my posts for today, I think I have to post some apologies...:blush:

I thought the SB one was amusing - and informative.

The black list one - I think a good point was made. But I think it is mostly for anybody coming after the fact.

I hope you didn't take my comment wrong - I made it in jest.

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

john.arnott SSChampion Points: 11882 More actions · Answer 14

CirquedeSQLeil (2/10/2010)
RBarryYoung (2/10/2010)
Steve Jones - Editor (2/10/2010)
Barry,
That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.
which one was that? I can't seem to find it.
Replacing the handshake with slapping the back of the head. Can't remember what company though.

That was a CBS network promo for one of the CSI shows.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

john.arnott (2/10/2010)
CirquedeSQLeil (2/10/2010)
RBarryYoung (2/10/2010)
Steve Jones - Editor (2/10/2010)
Barry,
That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.
which one was that? I can't seem to find it.
Replacing the handshake with slapping the back of the head. Can't remember what company though.
That was a CBS network promo for one of the CSI shows.

Probably NCIS - Jethro does that all the time

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]