Forum Replies Created

Viewing 15 posts - 151 through 165 (of 271 total)

  • RE: The Value of Code

    GeorgeCopeland (12/2/2014)

    marcia.j.wilson (12/2/2014)

    Like this e-mail that I got the day before Thanksgiving from someone who knew I was going to be off for a week in this time period: "We...

    December 2, 2014 at 1:15 pm

    #1762217

  • RE: The Value of Code

    GeorgeCopeland (12/2/2014)

    I know what you mean Steve, but I lose patience for business people who do not know what they want. You and I are technologists. We deliver solutions to...

    December 2, 2014 at 12:53 pm

    #1762209

  • RE: What Counts for a DBA: Empathy

    David.Poole (11/25/2014)

    As a manager I've come to realise that my role is not to chose the best option, it is to choose the least crap. Being British choosing the...

    November 25, 2014 at 4:34 pm

    #1760945

  • RE: Find the Most Recent Post

    TomThomson (11/24/2014)

    Nice question, but I have two queries about it:

    (i) why 2 points? it's just extremely simple logic.

    (ii) why use first_value and DESC when last_value would do, so that...

    November 24, 2014 at 8:30 am

    #1760545

  • RE: Find the Most Recent Post

    Koen Verbeeck (11/24/2014)

    Nice question. I have been bitten by the windowing functions defaults before, so this question was easy 😀

    (I even wrote a blog post about it: Beware the defaults!...

    November 24, 2014 at 8:27 am

    #1760543

  • RE: What Counts for a DBA: Empathy

    Louis Davidson (@drsql) (11/22/2014)

    Jeff Moden (11/22/2014)

    It seemed to me to be yet another article chastising the people who are actually concerned with what the customer actually received for the...

    November 22, 2014 at 1:09 pm

    #1760353

  • RE: Odd Man Out

    Sean Lange (11/20/2014)

    ...

    Suddenly I am singing Sesame Street "One of these things is not like the other, one of these things is kind of the same". 😛

    Oh, great. ...

    November 20, 2014 at 6:18 pm

    #1759991

  • RE: Odd Man Out

    Koen Verbeeck (11/20/2014)

    I'd argue ROWCOUNT_BIG is an odd one as well, as it is not calculated over the current result set, but over the results of a previous query.

    That's exactly...

    November 20, 2014 at 6:06 pm

    #1759988

  • RE: TSQL "where - 101"

    Ed Wagner (11/12/2014)

    h.tobisch (11/12/2014)

    From my standpoint :

    It should not be a programmer's responsibility (alas it sometimes is) to figure out what some quirky piece of code might be doing,

    but to...

    November 12, 2014 at 8:39 am

    #1758002

  • RE: Fun with RAND()

    Missed it due to carelessness. (Not noticing that it was < instead of <=). Well at least it taught me to pay more attention.

    Good question.

    November 5, 2014 at 2:40 pm

    #1756824

  • RE: Formatted output

    Thanks for the question and the comments. I have learned a lot from both today.

    October 29, 2014 at 2:28 pm

    #1755639

  • RE: Preventing recompile

    What's a scenario where it would make sense to use this?

    October 14, 2014 at 2:00 pm

    #1752313

  • RE: Which type of Numbers?

    john.moreno (10/9/2014)

    I thought it would be a frienfly question, so I picked Amicable numbers...

    Thanks. I enjoyed that response.

    October 9, 2014 at 8:22 am

    #1751313

  • RE: RAND Unions

    TomThomson (9/28/2014)

    Good question.

    Just like the last question on Random, I think the explanation could be improved.

    First, the misleading "for a connection" is there again. It...

    September 29, 2014 at 7:55 am

    #1748822

  • RE: How many rows will be returned?

    Sean Lange (9/23/2014)

    marcia.j.wilson (9/23/2014)

    I have a question about this. If the trigger executes once even if no rows are inserted, what happens if 5 rows are inserted at a...

    September 23, 2014 at 8:35 am

    #1747499

Viewing 15 posts - 151 through 165 (of 271 total)