Post reply

Are the posted questions getting worse?

  • January 5, 2011 at 10:16 am

    #1269620

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    And for those wanting more info, the contest is described here[/url]

    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

  • January 5, 2011 at 10:16 am

    #1269621

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    I'm glad I'm not the only one.

    Check my blog on the Facebook and SQLCruise[/url].

    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

  • January 5, 2011 at 10:29 am

    #1269628

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    Last time I checked, I had a Facebook account, but I don't think I've ever used it for anything.

    (LOL: I typoed it into "Farcebook", and now I've got that stuck in my mind as an idea for something.)

    Love the idea. I look forward to joining Farcebook when you have it set up.

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

  • January 5, 2011 at 10:31 am

    #1269630

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    I feel exactly the same way.

    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

  • January 5, 2011 at 10:33 am

    #1269631

    WayneS (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    And for those wanting more info, the contest is described here[/url]

    Ugh. Facebook. I can't wait until that hype is over 🙂

    (it can take a long time, since apparently someone thought it was worth spending 500 million dollars...)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 5, 2011 at 10:36 am

    #1269634

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in the Mariana Trench! EDIT: That includes C++.

    @=)

    What? There are programming languages that don't include the revolutionary new concept of "nullity" created by a self-proclaimed mathematical genius in the UK?

    http://scienceblogs.com/goodmath/2006/12/nullity_the_nonsense_number_1.php

    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number. If you plot the function 1/x with a program like maple, you can clearly see that the asymptotic value is infinity. (http://en.wikipedia.org/wiki/File:Hyperbola_one_over_x.svg)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 5, 2011 at 10:39 am

    #1269635

    CirquedeSQLeil (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    I'm glad I'm not the only one.

    Check my blog on the Facebook and SQLCruise[/url].

    And judging by all the responses, we are definitely not alone in this!

    Edit: I just posted a poll of how many use Facebook

    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

  • January 5, 2011 at 10:40 am

    #1269638

    Koen (da-zero) (1/5/2011)

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in the Mariana Trench! EDIT: That includes C++.

    @=)

    What? There are programming languages that don't include the revolutionary new concept of "nullity" created by a self-proclaimed mathematical genius in the UK?

    http://scienceblogs.com/goodmath/2006/12/nullity_the_nonsense_number_1.php

    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number. If you plot the function 1/x with a program like maple, you can clearly see that the asymptotic value is infinity. (http://en.wikipedia.org/wiki/File:Hyperbola_one_over_x.svg)

    That's because there is no "fuzz" about division by 0. It's a truly simple concept, that some math professor with a CS degree felt he had to complicate by "solving the huge, long-term problems with it". The BBC ran the story as if it were truly a revolution in math, instead of a crackpot who's teaching in primary schools because no self-respecting university would allow him on their staff outside of a janitorial position.

    - 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

  • January 5, 2011 at 10:44 am

    #1269641

    Koen (da-zero) (1/5/2011)

    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.

    However if you allow it, it's trivial to prove that 0 = 1. Hence the reason that dividing anything by 0 is undefined.

    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

  • January 5, 2011 at 11:02 am

    #1269656

    GilaMonster (1/5/2011)

    Koen (da-zero) (1/5/2011)

    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.

    However if you allow it, it's trivial to prove that 0 = 1. Hence the reason that dividing anything by 0 is undefined.

    If you think of 'infinity' as defined, then division by zero is (somewhat) defined. It's just not a "natural" concept.

    But hey, you can prove so much with math when using infinity. That 0.99999... (to infinity) is equal to 1 for example.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 5, 2011 at 11:06 am

    #1269658

    Koen (da-zero) (1/5/2011)

    GilaMonster (1/5/2011)

    Koen (da-zero) (1/5/2011)

    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.

    However if you allow it, it's trivial to prove that 0 = 1. Hence the reason that dividing anything by 0 is undefined.

    If you think of 'infinity' as defined, then division by zero is (somewhat) defined. It's just not a "natural" concept.

    But hey, you can prove so much with math when using infinity. That 0.99999... (to infinity) is equal to 1 for example.

    Of course, if you really want to mess with your own head, you can always assume because of graph charts and the like that -infinity = infinity, and the number line is actually a circle.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 5, 2011 at 9:23 pm

    #1269853

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for me to join Facebook?

    EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.

    Don't think of Facebook as this monster. You can do as much, or little, as you like. You don't have to enter personal information or friend other people (or accept friends).

    I'd like to do the cruise, but the timing doesn't work for me this year.

  • January 5, 2011 at 9:25 pm

    #1269855

    Just came back from a neighborhood meeting. Now I need to go shovel more manure around in my barn.

    Does anyone have a fork I can stick in my eye?

  • January 5, 2011 at 11:46 pm

    #1269875

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in the Mariana Trench! EDIT: That includes C++.

    @=)

    What? There are programming languages that don't include the revolutionary new concept of "nullity" created by a self-proclaimed mathematical genius in the UK?

    http://scienceblogs.com/goodmath/2006/12/nullity_the_nonsense_number_1.php

    It's amazing how quickly people who believe the world to be flat will badmouth those proposing it to be otherwise. 😉

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

  • January 5, 2011 at 11:53 pm

    #1269878

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in the Mariana Trench! EDIT: That includes C++.

    @=)

    What value would you like returned if 0 is the divisor? Personally, I'd prefer a NULL to be returned instead of an error (which also means I think the guy doing all the badmouthing on the link that Gus provided should probably reexamine his position on the subject;-) ). Here's some typical code I use to do such a thing in T-SQL...

    SELECT @SomeNumber/NULLIF(@SomeOtherNumber,0)

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

Viewing 15 posts - 22,966 through 22,980 (of 66,712 total)

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