March 9, 2009 at 2:43 pm
Lynn, you left out one benefit of traveling. It also makes it easier to beat some sense into them. Of course, only AFTER you've been paid.
😀
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]
March 9, 2009 at 2:48 pm
Alvin Ramard (3/9/2009)
Lynn, you left out one benefit of traveling. It also makes it easier to beat some sense into them. Of course, only AFTER you've been paid.😀
True, very true. But you also have to keep the beating verbal, as you don't want to end up in jail in some of those exotic locals! 😉
March 9, 2009 at 2:52 pm
Lynn Pettis (3/9/2009)
Alvin Ramard (3/9/2009)
Lynn, you left out one benefit of traveling. It also makes it easier to beat some sense into them. Of course, only AFTER you've been paid.😀
True, very true. But you also have to keep the beating verbal, as you don't want to end up in jail in some of those exotic locals! 😉
True
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]
March 9, 2009 at 3:02 pm
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back that your rates are $500/hour....
If I had any expectations they were willing to pay, I'd send them my rate and details on the company. Somehow though, I don't think they want to spend money to get answers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2009 at 3:13 pm
GilaMonster (3/9/2009)
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back that your rates are $500/hour....
If I had any expectations they were willing to pay, I'd send them my rate and details on the company. Somehow though, I don't think they want to spend money to get answers.
We know that they aren't willing to pay. That is why they are contacting us via SSC. Hey, it's free help, let's try them. I guess they don't stop to think that maybe the help we provide on the forums is voluntary, without expectation of renumeration.
March 9, 2009 at 3:30 pm
I guess they don't stop to think that maybe the help we provide on the forums is voluntary, without expectation of renumeration.
It may be that they know it's voluntary, but they just don't care. It's free to them. One should never assume that all people are altruistic, empathetic, or even mildly considerate of others.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 3:39 pm
Bob Hovious (3/9/2009)
One should never assume that all people are altruistic, empathetic, or even mildly considerate of others.
Where have I heard this idea before? Oh, right - http://www.sqlservercentral.com/articles/Editorial/65532/
---------------------------------------------------------
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."
March 9, 2009 at 4:05 pm
Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be a default. But don't get me wrong, I'm not pining for the "good old days" because they were worse in many respects.
The world is in a global economic crisis right now in large part because of people who were simply acting in their own best interests. Lenders made loans on homes regardless of whether or not the borrowers had an ability to repay because, after all, commisions are paid on those loans and there was no personal downside if the borrower defaulted in later years. Some institutions rolled up big profits for a few years because they took short term risk and created ways to transfer the risk to others. Other institutions had to follow suit, because their boards and investors demanded that their CEOs produce the same high return on investment. When the bubble burst, many of them went down the tubes taking a huge portion of the world with it. But some few are walking away wealthier because of it. I don't think those people are evil. They just did what the system allowed. Nobody wanted a crash to happen, but only stricter regulation could have prevented it.
Auditing/accountability comes too late. At this point we could have accountability to the point of lopping off heads, but it is still too late for the millions of people who are suffering the consequences through no fault of their own.
I trust most people to act in their own interests. They rarely disappoint me 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:08 pm
Anybody for another "Queen" sing-a-long?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:16 pm
GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.That is too funny! Nearly choked on my sprite when I read that!
Heh... I'm still trying to dislodge the pork chop out of the wall that I blew out of my nose...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 9, 2009 at 4:18 pm
Bob Hovious (3/9/2009)
Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be a default. But don't get me wrong, I'm not pining for the "good old days" because they were worse in many respects.The world is in a global economic crisis right now in large part because of people who were simply acting in their own best interests. Lenders made loans on homes regardless of whether or not the borrowers had an ability to repay because, after all, commisions are paid on those loans and there was no personal downside if the borrower defaulted in later years. Some institutions rolled up big profits for a few years because they took short term risk and created ways to transfer the risk to others. Other institutions had to follow suit, because their boards and investors demanded that their CEOs produce the same high return on investment. When the bubble burst, many of them went down the tubes taking a huge portion of the world with it. But some few are walking away wealthier because of it. I don't think those people are evil. They just did what the system allowed. Nobody wanted a crash to happen, but only stricter regulation could have prevented it.
Auditing/accountability comes too late. At this point we could have accountability to the point of lopping off heads, but it is still too late for the millions of people who are suffering the consequences through no fault of their own.
I trust most people to act in their own interests. They rarely disappoint me 😉
I wake up in the morning distrusting everyone... and then I make exceptions for the day from there.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 9, 2009 at 4:24 pm
GilaMonster (3/9/2009)
GSquared (3/9/2009)
Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples. Not the usual stuff, but looked valid to me.Yeah, just read through it now. It's not that the group by was returning duplicate rows, it wasn't, but with only part of the group by clause being returned that wasn't obvious.
Definitely not a normal case.
The only that I ever had problems with group by is when the group bys and the select didn't match perfectly, IE case when in the select, then put those columns in the group by. Other than that I never had distinct show different results than group by.
March 9, 2009 at 4:41 pm
The only that I ever had problems with group by is when the group bys and the select didn't match perfectly
In olden days, when the pictures on the TV were still hand-carved, there was a show called Hee Haw, which my father loved. One of their regular skits was someone walking in and saying "Doc, it hurts when I do that." The doctor would smack them over the head and yell " Well don't DO that !! "
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 5:54 pm
K. Brian Kelley (3/9/2009)
Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server.
Even with the explanation on the DAC some folks are putting the logon trigger in place and having a hard time undoing it after they effectively prevent themselves from logging in.
Buck Woody has a disclaimer blog post that he links to for these things. It's here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2009 at 6:25 pm
[font="Verdana"]Good disclaimer. Good quote of the day too!
"I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." - Bjarne Stroustrup
[/font]
Viewing 15 posts - 2,446 through 2,460 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply