Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 7,484 total)

  • RE: On formatting SQL code

    Eric M Russell (3/28/2016)


    The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.

    You have my deepest sympathy.

    I wrote some of that sort...

  • RE: On formatting SQL code

    robert.sterbal 56890 (3/28/2016)


    With 61 responses here are some basic stats:

    ....

    ....

    It would be nice to have a chart of years vs format-score, plus maybe 5 year moving average. but I'm...

  • RE: On formatting SQL code

    Lynn Pettis (3/28/2016)


    diamondgm (3/26/2016)


    The results should be visible here

    If the BI gods do their thing, the report should update hourly

    You should also be able to download the data by clicking...

  • RE: On formatting SQL code

    Eric M Russell (3/28/2016)


    Clean SQL runs better for the same reason that a clean car runs better. It's simply that those same developers who take time to format their code...

  • RE: Understanding Implicit_Transaction on - INSERT block SELECT - why?

    Warning: I'm basing my response on how a different compny planned to do it 15 or 16 years before Microsoft did it, because I haven't seen much detail on the...

  • RE: Understanding Implicit_Transaction on - INSERT block SELECT - why?

    szejiekoh (3/27/2016)


    Q1) so with that being said, can i say that this behavior (uncomitted insert blocking select ) is actually behaving as intended in sql server ?

    Yes, this is...

  • RE: On formatting SQL code

    The survey results so far look pretty much in favour of having some sort of formatting standard, but the number responding is very small which maybe indicates that a lot...

  • RE: Understanding Implicit_Transaction on - INSERT block SELECT - why?

    Here's one way of looking at it (if you have time for a lot of heavy reading it might be useful to learn to understand it in terms of the...

  • RE: The SIGN

    sknox (3/25/2016)


    Good question, but the explanation is wrong on one point:

    The MIN() and MAX() functions are aggregates, therefore the NULL is eliminated.

    is not true.

    The reason the NULL is...

  • RE: Today's Random Word!

    djj (3/24/2016)


    H2

    O

  • RE: Do Less

    Gary Varga (3/24/2016)


    I am often shocked about how many IT graduates have not been taught the fundamentals of different programming paradigms. Or even that there are different ones. I am...

  • RE: Today's Random Word!

    Ed Wagner (3/23/2016)


    Claymore

    Broadsword

  • RE: Opinions on triggers

    I too agree with what Hugo has said.

    There are some cases where a trigger is the wrong way to do something. Wherever possible, data integrity should be enforced by...

  • RE: The Endpoint IP

    Interesting question.

    It seems to me that if something has both a V4 IP and a V6 IP and isn't told to listen on only one of them that will be...

  • RE: The New Men of IT

    David.Poole (3/21/2016)


    I'm extremely wary of LinkedIn endorsements. I've been endorsed by people I've never heard of for skills I didn't know I had.

    Me too. I have endorsements for...

Viewing 15 posts - 1,126 through 1,140 (of 7,484 total)