Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 7,484 total)

  • RE: SQL query help

    CELKO (4/21/2015)


    We do not store computed values in a table and we seldom use FLOAT for anything; the rounding errors are illegal in most commercial applications. Do you really measure...

  • RE: Email In The Bathroom: Not A Universal Good

    The advert is, of course, appalling. There needs to be space in life to be not working, so I hope the advert is more of a joke that a...

  • RE: How long do they last?

    Sean Lange (4/23/2015)


    Excellent question. I got it right by deduction more than understanding. I figured the scalar would run for each row but I would have thought the itvf would...

  • RE: Embrace Stored Procedures

    teodorom (4/22/2015)


    Apart that I am an (exclusively) strong supporter of the stored procedures.

    That is, given any business problem, I've never seen a situation where it was worthwhile not to use...

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/22/2015)


    djj (4/22/2015)


    Eirikur Eiriksson (4/21/2015)


    SQLRNNR (4/21/2015)


    fecal fabric flinging fairies

    Pixie Dust

    Neverland

    Dragons

    Dungeons

  • RE: T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures?

    It's a good idea to do some logging when an error are detected, as well as trying to recover or contain the error.

    And of course code defensively (detect the impossible...

  • RE: RTRIM is not working as expected

    I find it hard to understand why you think it should not return 32.

    You are generating a column called [dim_vArticlesStyleDescription0_7] which is a copy of [StyleDescription] with the trailing...

  • RE: Today's Random Word!

    Ed Wagner (4/21/2015)


    Eirikur Eiriksson (4/21/2015)


    Ed Wagner (4/21/2015)


    crookj (4/21/2015)


    TomThomson (4/21/2015)


    Revenant (4/21/2015)


    djj (4/21/2015)


    Ed Wagner (4/21/2015)


    eccentricDBA (4/21/2015)


    Eirikur Eiriksson (4/21/2015)


    Ed Wagner (4/21/2015)


    Eirikur Eiriksson (4/21/2015)


    SQLRNNR (4/21/2015)


    faint

    distant

    Far

    Fetched

    idea

    Start

    Finish

    Line

    Dance

    Disco

    Dead

    Beat

    Rhythm

    Blues

  • RE: Today's Random Word!

    Revenant (4/21/2015)


    djj (4/21/2015)


    Ed Wagner (4/21/2015)


    eccentricDBA (4/21/2015)


    Eirikur Eiriksson (4/21/2015)


    Ed Wagner (4/21/2015)


    Eirikur Eiriksson (4/21/2015)


    SQLRNNR (4/21/2015)


    faint

    distant

    Far

    Fetched

    idea

    Start

    Finish

    Line

    Dance

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/20/2015)


    Ed Wagner (4/20/2015)


    Eirikur Eiriksson (4/20/2015)


    Ed Wagner (4/20/2015)


    crookj (4/20/2015)


    Eirikur Eiriksson (4/20/2015)


    Ed Wagner (4/20/2015)


    Eirikur Eiriksson (4/20/2015)


    djj (4/20/2015)


    crookj (4/20/2015)


    Ed Wagner (4/20/2015)


    SQLRNNR (4/20/2015)


    wildcard

    Match

    Set

    Group

    Fuzzy

    Algorithm

    Jazz

    Band

    Metallica

    Fossilized

    Dig

    Trench

    Warfare

  • RE: Embrace Stored Procedures

    Interesting discussion.

    I think Conery's article is excellent, never mind the phrasing look at what is being said.

    It's a pity that some people seem to believe that using stored procedures for...

  • RE: Using LAG

    Hugo Kornelis (4/19/2015)


    Oh, I absolutely am with you on the assumption that the data being queries is already aggregated on a per-month basis. I now, upon rereading, realise that my...

  • RE: ISNULL vs COALESCE

    Hugo Kornelis (4/18/2015)


    I personally think the first case is already crazy (who would ever type a literal NULL as the first argument to ISNULL anyway??). But for the sake of...

  • RE: NONclustered 2 clustered

    patricklambin (4/18/2015)


    Thanks for this question which seems very simple and evident ( at least it is my own opinion ).

    I am surprised that only half of the voters have found...

  • RE: Using LAG

    Hugo Kornelis (4/15/2015)


    But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

Viewing 15 posts - 1,786 through 1,800 (of 7,484 total)