Are the posted questions getting worse?

  • Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    mtillman-921105 (8/29/2011)


    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as a revelation to them.

    I'm afraid that's also true here in the U.S.

    Your politicians aren't discussing how to nationalise the banks and mines and how to redistribute land without compensation...

    BWAA-HAA!!! My friends that are being foreclosed upon because Congress allowed (and encouraged) the banks to give loans to people, who could never afford it, would disagree.

    But, I will most definitely agree... we don't have the same level of problems that are present in some other countries.... at least not yet (knocks on wood).

    Yep, unfettered capitalism doesn't work either.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • I wish I could say "Yes" to try to help the person feeling infringed upon but, No I don't. Not even at the code level especially since one wrote a proc for the "3rd item" and the other wrote a function. There are a whole lot of other differences. Even in the simplistic code of the 2nd proc, there are a huge number of differences and even a different style which is actually amazing to me because there're only so many ways to write such simple code.

    So far as the binary thing goes, Ben-Gan used it long before either of them did....

    http://books.google.com/books?id=yVv9CiyYUaAC&pg=PT745&lpg=PT745&dq=substring(isnull(context_info(),&source=bl&ots=68Aa4UXWor&sig=uH3J6WZxWyIR2irWF07c-f-4oks&hl=en&ei=4U5cTo3IEazE0AH47KWOAw&sa=X&oi=book_result&ct=result&resnum=5&ved=0CDUQ6AEwBA#v=onepage&q=substring(isnull(context_info()%2C&f=false

    ...and a million other people, including me, have used @ProcID as a variable to hold the value @@ProcID for many other things, as well.

    The only two things the two articles really have in common is the order of revelation (I have to admit, I'd have used the same order) and the fact that the 3rd item in both is total crap code. πŸ˜€

    --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)

  • Jeff Moden (8/29/2011)


    I wish I could say "Yes" to try to help the person feeling infringed upon but, No I don't. Not even at the code level especially since one wrote a proc for the "3rd item" and the other wrote a function. There are a whole lot of other differences. Even in the simplistic code of the 2nd proc, there are a huge number of differences and even a different style which is actually amazing to me because there're only so many ways to write such simple code.

    So far as the binary thing goes, Ben-Gan used it long before either of them did....

    http://books.google.com/books?id=yVv9CiyYUaAC&pg=PT745&lpg=PT745&dq=substring(isnull(context_info(),&source=bl&ots=68Aa4UXWor&sig=uH3J6WZxWyIR2irWF07c-f-4oks&hl=en&ei=4U5cTo3IEazE0AH47KWOAw&sa=X&oi=book_result&ct=result&resnum=5&ved=0CDUQ6AEwBA#v=onepage&q=substring(isnull(context_info()%2C&f=false

    ...and a million other people, including me, have used @ProcID as a variable to hold the value @@ProcID for many other things, as well.

    The only two things the two articles really have in common is the order of revelation (I have to admit, I'd have used the same order) and the fact that the 3rd item in both is total crap code. πŸ˜€

    Well, I didn't even know about Ben-Gan's code and I haven't read that book, but I've been using CONTEXT_INFO() to store the "call stack" since 2007.

    Actually, I don't store the whole call stack, because it would require to PUSH at the beginning of the procedure and POP at the end and you would have to do it for each possible code path. Personally, I don't like in my code lines that do something other than the purpose of the procedure and are there just for "internal use". Also, I would never rely on that stack, because the PUSH/POP thing would have to be in every single procedure and we all know how difficult it could get to ensure.

    For these reasons, I only store the caller procedure name in CONTEXT_INFO. It comes handy sometimes.

    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    -- Gianluca Sartori

  • Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    mtillman-921105 (8/29/2011)


    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as a revelation to them.

    I'm afraid that's also true here in the U.S.

    Your politicians aren't discussing how to nationalise the banks and mines and how to redistribute land without compensation...

    BWAA-HAA!!! My friends that are being foreclosed upon because Congress allowed (and encouraged) the banks to give loans to people, who could never afford it, would disagree.

    If so then your friends don't understand what nationalisation means.

    There's a big difference between the government encouraging certain behaviour from a non-government organisation and the government owning and running said organisation.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Similarities, YES. But plagiarism NO. There are way too many articles about each topic that there is a chance that the flow of the article might be the same in some cases. Maybe the second author did get the inspiration from the first ones article.

    -Roy

  • This one made me smile.

    "Close the ticket". :hehe:

    I think he confused SSC with MS support.

    -- Gianluca Sartori

  • GilaMonster (8/30/2011)


    Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    mtillman-921105 (8/29/2011)


    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as a revelation to them.

    I'm afraid that's also true here in the U.S.

    Your politicians aren't discussing how to nationalise the banks and mines and how to redistribute land without compensation...

    BWAA-HAA!!! My friends that are being foreclosed upon because Congress allowed (and encouraged) the banks to give loans to people, who could never afford it, would disagree.

    If so then your friends don't understand what nationalisation means.

    There's a big difference between the government encouraging certain behaviour from a non-government organisation and the government owning and running said organisation.

    Actually, in the US, the government does own and run the two biggest companies in that particular arena (Fannie Mae and Freddie Mack).

    The odd bit about US nationalization is that the Federal Reserve Bank, which issues all our paper money, is privately owned. Most people think it's a government entity, but it's not. It's not even some "they have hidden conspiracy-theory-type ownership", it's right there in the charter and all that. I think people assume it's government because of the word "federal" in its name.

    The US is weird about "nationalized" corporations. The government doesn't typically own companies outright, but it has more say over some companies' day-to-day operations, policies, and procedures, than the board of directors of the company.

    - 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

  • GSquared (8/30/2011)


    Actually, in the US, the government does own and run the two biggest companies in that particular arena (Fannie Mae and Freddie Mack).

    Yes, I know. And they buy mortgages or whatever from the banks, package them up and sell as investments or such sillyness. But you don't open savings accounts directly with Fannie Mae, the US government doesn't own the Bank of America (as one example), it has shareholders from private sector.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Tom.Thomson (8/29/2011)


    GilaMonster (8/29/2011)


    Jeff Moden (8/29/2011)


    GilaMonster (8/29/2011)


    mtillman-921105 (8/29/2011)


    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as a revelation to them.

    I'm afraid that's also true here in the U.S.

    Your politicians aren't discussing how to nationalise the banks and mines and how to redistribute land without compensation...

    If that's what your government is discussing it's talking about fairly extreme state socialism, not real communism. State socialism is of course the starting point for totalitarian pseudo-communism as practised by Lenin and Stalin, and has no connection at all with real (Marxist or anarchistic) communism, syndicalism, or anarchic syndicalism, and only a slight connection with anarchistic socialism.

    That would come as a revelation to the local communist party. πŸ™‚

    It's what you get when some of the leaders of the ruling party revere Pres Mugabe as a shining example of the 'african agenda'

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (8/30/2011)


    GSquared (8/30/2011)


    Actually, in the US, the government does own and run the two biggest companies in that particular arena (Fannie Mae and Freddie Mack).

    Yes, I know. And they buy mortgages or whatever from the banks, package them up and sell as investments or such sillyness. But you don't open savings accounts directly with Fannie Mae, the US government doesn't own the Bank of America (as one example), it has shareholders from private sector.

    Very true.

    Like I said, we're weird about this one. We halfway nationalize stuff, but really just stick with the worst of both worlds. We get as many of the downsides of nationalizing as we can while still lying to ourselves that it's "private industry capitalism", while keeping as many of the downsides of private industry as we can by lying to ourselves that "the gub'ment is pertectin' us". So, we get the FDA putting warning labels on certain drugs saying they're likely to kill you, the year after the patents run out and "Big Pharma" can no longer make any significant profits on them. And we get Bank of America being ordered by the Treasury Dept to buy a certain "Too Big to Fail, Too Unethical to Succeed" company, and then being chastised by the Treasury Sec for doing exactly that as soon as it's politically advantageous for him to target "big, greedy corporations".

    - 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

  • Gianluca Sartori (8/30/2011)


    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    You must not sing the blues...

    ---------------------------------------------------------
    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."

  • jcrawf02 (8/30/2011)


    Gianluca Sartori (8/30/2011)


    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    You must not sing the blues...

    I prefer hard-rock. πŸ˜›

    -- Gianluca Sartori

  • Gianluca Sartori (8/30/2011)


    jcrawf02 (8/30/2011)


    Gianluca Sartori (8/30/2011)


    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    You must not sing the blues...

    I prefer hard-rock. πŸ˜›

    Oh, well then you only need two notes... πŸ˜›

    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

  • WayneS (8/30/2011)


    Gianluca Sartori (8/30/2011)


    jcrawf02 (8/30/2011)


    Gianluca Sartori (8/30/2011)


    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    You must not sing the blues...

    I prefer hard-rock. πŸ˜›

    Oh, well then you only need two notes... πŸ˜›

    I knew somebody would have said that.

    πŸ™‚

    -- Gianluca Sartori

  • WayneS (8/30/2011)


    Gianluca Sartori (8/30/2011)


    jcrawf02 (8/30/2011)


    Gianluca Sartori (8/30/2011)


    On the plagiarism, I don't see it. After all, musical notes are just seven. πŸ˜‰

    You must not sing the blues...

    I prefer hard-rock. πŸ˜›

    Oh, well then you only need two notes... πŸ˜›

    You use notes in your hard rock???? Wow! It sure has changed since I was listening to it in the '80s!!!

    - 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

Viewing 15 posts - 29,461 through 29,475 (of 66,712 total)

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