Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 7,484 total)

  • RE: Table Variable

    ronmoses (4/30/2013)


    So here's a question. If variables are initialized at parsing time - I take this to mean that the DECLARE is interpreted prior to the INSERT - why...

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/30/2013)


    dbursey (4/29/2013)


    jcrawf02 (4/29/2013)


    L' Eomot Inversé (4/28/2013)


    dbursey (4/26/2013)


    jcrawf02 (4/25/2013)


    L' Eomot Inversé (4/24/2013)


    jcrawf02 (4/24/2013)


    Lynn Pettis (4/23/2013)


    L' Eomot Inversé (4/23/2013)


    Jeff Moden (4/23/2013)


    Heh... to complicated. Just take Jason.A to work and let...

  • RE: Schemas vs Several Databases

    I guess that what you apparently want to use schemas for is what MS intended to provide by providing complete separation between the schema concept and the user concept. ...

  • RE: Table Variable

    Nice fun question, clear explanation, back to basics of variable declarations.

    Of course MS have got the documentation wrong yet again - this is another one of those. The the...

  • RE: Today's Random Word!

    crookj (4/29/2013)


    Revenant (4/29/2013)


    Batmobile

    The Black Beauty (and what show is this from?) 😉

    Why switch from wheels or wings to legs?

  • RE: QUERY and TABLE HINTS

    Hugo Kornelis (4/29/2013)


    Just to prevent misunderstandings - I did not intent my post to imply that one can leave out the WITH. The current version of SQL Server may be...

  • RE: QUERY and TABLE HINTS

    Hugo Kornelis (4/29/2013)


    Too bad the question author somewhere switched the two options in his head and marked the wrong answers as right and the right answers as wrong. Fortunately, I...

  • RE: QUERY and TABLE HINTS

    zerko (4/28/2013)


    Tom, yes I noted the deprecation issue - it's not that ...

    Question says "Which of the following hints require the word WITH? (choose 3) "

    Explanation says "table hints...

  • RE: A Check and Foreign Key Constraint Improves Query Performance

    Evil Kraig F (4/26/2013)


    Grant Fritchey (4/26/2013)


    TheGreenShepherd (4/26/2013)


    Don't mean to pile on here, but yeah. I fail to understand why someone would query this data in this fashion. Yeah, it improves...

  • RE: A Check and Foreign Key Constraint Improves Query Performance

    accidental post - deleted

  • RE: QUERY and TABLE HINTS

    zerko (4/28/2013)


    the joys of answering early :pinch: -

    The QotD question states "Which of the following hints require the word WITH? (choose 3) "

    I don't use Table Hints that...

  • RE: Are the posted questions getting worse?

    dbursey (4/26/2013)


    jcrawf02 (4/25/2013)


    L' Eomot Inversé (4/24/2013)


    jcrawf02 (4/24/2013)


    Lynn Pettis (4/23/2013)


    L' Eomot Inversé (4/23/2013)


    Jeff Moden (4/23/2013)


    Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories...

  • RE: A Check and Foreign Key Constraint Improves Query Performance

    I missed this somehow when it first came out - or at least I don't recall it. It's a good and interesting article, but I think it would have...

  • RE: Nested triggers 1

    Carlo Romagnano (4/23/2013)


    What is the difference between the answer 3 and 6?

    5, 3, 1

    I don't think there is any. But the answers may tell us two interesting things: ...

  • RE: Complex many to many relationships

    ChrisM@Work (4/25/2013)


    What might you gain by putting phone numbers into a table separate from the entity (client, agent whatever) to which they belong?

    Maybe the entity owning the phone number has...

Viewing 15 posts - 3,541 through 3,555 (of 7,484 total)