Forum Replies Created

Viewing 15 posts - 91 through 105 (of 235 total)

  • RE: ACID Properties

    Durable temporary object. Nice idea.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Control chars in XML

    codebyo (9/3/2011)


    Which IE version? One should be very careful to post an answer referring to a specific application without an explicit version. Sorry but not all machines will have the...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: How to use temporary table in function

    Nice one. I hope I remember it the moment I (or someone else) will need it.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: GO

    DugyC (6/7/2011)


    honza.mf (6/7/2011)


    WayneS (6/6/2011)


    Actually, none of those choices are correct. You get back 50 random GUID values.

    1. NEWID() returns a random GUID (aka uniqueidentifier)

    2. Select statement has no order by...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: GO

    WayneS (6/6/2011)


    Actually, none of those choices are correct. You get back 50 random GUID values.

    1. NEWID() returns a random GUID (aka uniqueidentifier)

    2. Select statement has no order by clause, so...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Restoring Editions

    Koen Verbeeck (5/6/2011)


    tommyh (5/6/2011)


    honza.mf (5/5/2011)


    20 optimists now.

    Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both?...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Restoring Editions

    tommyh (5/6/2011)


    Hrmmm... in this case whats an optimist. One that thinks it will work or one that thinks it will fail at once... or both? :unsure:

    /T

    Optimist is a person, who...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Restoring Editions

    20 optimists now.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: What's Today?

    JestersGrind (4/15/2011)


    Today is also the day that the Titanic sank and President Abraham Lincoln died.

    Doh!! Someone beat me to it!

    I wanted something of our history but found nothing really...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: What's Today?

    Today is a 99th anniversary of Titanic sinking.

    Abraham Lincoln dies in 1865

    ...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Relational Theory

    Only seven points for such a hard question? (23% of bad answers!)

    Good All fools day to all.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Nulls

    tommyh (12/8/2010)


    honza.mf (12/8/2010)


    tommyh (12/8/2010)


    The QOTD isnt there for us to score points...

    It's easy to say this if you have one thousand points 😀

    Those points also go up from...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Nulls

    tommyh (12/8/2010)


    The QOTD isnt there for us to score points...

    It's easy to say this if you have one thousand points 😀



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Nulls

    Toreador (12/8/2010)


    da-zero (12/8/2010)


    Some people are still working with earlier versions of SQL Server.

    But hopefully none of them are still using ANSI_NULLS OFF or any other deprecated features?

    Some old applications are...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Nulls

    savosin_sergey (12/7/2010)


    Yes, question is instrustive (for me), but BOL says:

    Caution:

    Any null values returned by subquery or expression that are compared to test_expression using IN or NOT IN return...



    See, understand, learn, try, use efficient
    © Dr.Plch

Viewing 15 posts - 91 through 105 (of 235 total)