Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 11,341 through 11,355 (of 66,712 total)

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

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

RBarryYoung (2/11/2010)
GilaMonster (2/11/2010)
RBarryYoung (2/10/2010)
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.
Barry, have you ever used Service Broker and triggers to move data from one DB to another? If so, can I mail you and chat about pros, cons and gotchas?
I sure have, so feel free to email me. One caveat, it's my bedtime here (3:30am), and I have a medical procedure tomorrow, so I won't see your stuff until late afternoon at best.

I hope I'm not being presumptuous here, but I would love to be involved in this question, if nothing more as an observer. I have definite interest in this area as well.

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

RBarryYoung (2/10/2010)
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.

Barry, please tell me this was tongue-in-cheek. I read your response, several times, and actually enjoyed it and Gus's followup. It was quite appropriate and actually appreciated. This may seem wrong or self-serving, but I felt vindicated by your response and support. I realize I tend to continue working with "difficult" op's when others have walked away and suggested the same to me as well, but that is just me. I wish I could have answered the op in that thread in as eloquent a manner as you.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Thanks Lynn. as for the SB stuff, I am OK with it if Gail does not mind...

[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]

WayneS SSC Guru Points: 95460 More actions · Answer 4

Lynn Pettis (2/11/2010)
RBarryYoung (2/11/2010)
GilaMonster (2/11/2010)
RBarryYoung (2/10/2010)
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.
Barry, have you ever used Service Broker and triggers to move data from one DB to another? If so, can I mail you and chat about pros, cons and gotchas?
I sure have, so feel free to email me. One caveat, it's my bedtime here (3:30am), and I have a medical procedure tomorrow, so I won't see your stuff until late afternoon at best.
I hope I'm not being presumptuous here, but I would love to be involved in this question, if nothing more as an observer. I have definite interest in this area as well.

[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]

Strong the Force will be. 😎

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]

GSquared SSC Guru Points: 260824 More actions · Answer 6

WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]

I'm not sure that's the tag you wanted, Wayne.

Dictionary definition: physic noun: a purging medicine; stimulates evacuation of the bowels

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

David Burrows SSC Guru Points: 65142 More actions · Answer 7

GSquared (2/12/2010)
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: a purging medicine; stimulates evacuation of the bowels

I thought he meant he was barfing on his keyboard whilst typing :sick:

Far away is close at hand in the images of elsewhere.
Anon.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 8

it is carnival weekend here. From tonight onwards it is "Drink, Dance and Be merry" here. 🙂 I think I will not be sober till Wednesday.. :hehe:

-Roy

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

Roy Ernest (2/12/2010)
it is carnival weekend here. From tonight onwards it is "Drink, Dance and Be merry" here. 🙂 I think I will not be sober till Wednesday.. :hehe:

Try not to get into too much trouble. :w00t:

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

David Burrows (2/12/2010)
GSquared (2/12/2010)
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: a purging medicine; stimulates evacuation of the bowels
I thought he meant he was barfing on his keyboard whilst typing :sick:

And I thought it was something scientific.

Now we have a Physic Bear throwing pork chops?

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

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 11

Steve Jones - SSC Editor

SSC Guru

Points: 736222

February 12, 2010 at 9:32 am

#1118113

That's an image I can do without.

tosscrosby SSCoach Points: 18045 More actions · Answer 12

Roy Ernest (2/12/2010)
"Drink, Dance and Be merry" :hehe:

Just as long as it's not "Drink, dance and be Mary"...Although, in this day and age, who really cares!

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

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 13

tosscrosby-60625 (2/12/2010)
Roy Ernest (2/12/2010)
"Drink, Dance and Be merry" :hehe:
Just as long as it's not "Drink, dance and be Mary"...Although, in this day and age, who really cares!

Maybe it's Drink, Dance, and be Merry?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 14

Roy Ernest (2/12/2010)
it is carnival weekend here. From tonight onwards it is "Drink, Dance and Be merry" here. 🙂 I think I will not be sober till Wednesday.. :hehe:

As your level of intoxication increases, remember the rules.... "Pillage first... then burn". It gets real embarassing if you do it the other way around. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

While reading the thread for today's headline article, I thought of an excellent interview question:

"What is the most important data in the world?"

I think you could gain plenty of insight into the candidate from that question. Canned answers could be determined, sincerity determined, and BS can be determined. You would be able to determine how much they like being a DBA or want to be a DBA.

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