Forum Replies Created

Viewing 15 posts - 7,381 through 7,395 (of 7,484 total)

  • RE: Introduction to Indexes: Part 2 – The clustered index

    bob 54859 (11/12/2009)


    Of course, dev manager vs architect... you know who wins. That's ok, I have bigger fish to fry. 😉

    BOb

    Actually, I don't know who wins. It will depend...

  • RE: A Bad Litmus Test

    What a poor list! It has a couple of really good people on it, and rather a lot of over-hyped also-rans. It omits people who are far more relevant...

  • RE: An Un-indexed Foreign Key Gotcha

    A really nice article. Good explanation.

    Tom

  • RE: Preventing usage of "SELECT *..."

    Jason Lees-299789 (11/11/2009)


    I would be very suprised if Select * ever disappears, while not best practice its great when you are diving around an unfamiliar Database or one that doesnt...

  • RE: Coincidence or Causality

    Paul White (1/11/2010)


    Tom.Thomson (1/10/2010)


    Steve Jones - Editor (12/13/2009)


    Deadlocks don't occur within a query, they are within a transaction when you are updating two objects.

    They can't in theory occur within a...

  • RE: Coincidence or Causality

    Steve Jones - Editor (12/13/2009)


    Deadlocks don't occur within a query, they are within a transaction when you are updating two objects.

    They can't in theory occur within a transaction, they occur...

  • RE: UNION error

    Lynn Pettis (1/26/2009)


    Tom.Thomson (1/26/2009)


    J (11/6/2008)


    Sorry - you were wrong

    No. YOU ARE wrong.

    It does not matter if there are duplicates or not, because the question specifically mentioned that there were no...

  • RE: Substring comprehension

    As some previous commenters did, I got this right by guessing what the questioner had got wrong.

  • RE: Just For Fun: An Impossible Delete

    Nice article. I liked very much seeing the "temp-in-place" technique applied, I guess it's very rare these days.

    But I didn't recognise the description of the early 70s. I started...

  • RE: The Value of Experience

    I think a dba (other than a junior trainee dba) should have experience in at least two other areas of computing and should understand the business (that understanding will usually...

  • RE: Data and Customer Service

    I wish the world were like what is described in the editorial. But even over here, where we have pretty strong data protection laws, it isn't like that. Mostly...

  • RE: File Groups

    Ouch -you got me - I didn't notice "clustered".

    And I've complained about people not reading questions carefully:blush:!

  • RE: The Future of Bits

    Bits or real-world objects - will it be either? Can we be sure that there won't be another big shift like the one that took place between 1950...

  • RE: Afraid of Help

    Elliott W (11/4/2009)


    I have to admit that while there are a lot of good SQL resources out there as evidenced by the big contributors on this forum, there are a...

  • RE: Afraid of Help

    weitzera (11/4/2009)


    That's a pretty well thought-out Reply Tom. Got any pointers on how to avoid these risks? (Other than not taking the job in the first place 🙂 ...

Viewing 15 posts - 7,381 through 7,395 (of 7,484 total)