Forum Replies Created

Viewing 15 posts - 46 through 60 (of 321 total)

  • RE: Rowcount and multiple assignment

    That was fun and surprising. I didn't notice the quirky update until I ran it.

    Thanks for a good QotD.

    Rune Bivrin (4/14/2010)


    It's important to note that SET @result = cast (@@rowcount...

  • RE: The Log Shipping Standard

    James Stover (4/12/2010)


    I'm a fan of log shipping. It's a hardened bit of technology that works very well.

    Having said that, isn't it time to improve on the file-based transaction log?...

  • RE: Understanding and Using APPLY (Part 1)

    Thanks Paul. Nice work, and I'm looking forward to part 2.

  • RE: Essential Software

    Phil Factor (4/9/2010)


    OK. If we are doing confessional stuff here, I'd have to admit I still use Access as an occasional way of getting a large range of Excel...

  • RE: Security

    Steve Cullen (4/9/2010)


    Sometimes it pays to guess. 😀

    ...and sometimes it doesn't. :crying:

  • RE: Report Server Web Service

    David Burrows (4/9/2010)


    SSRS 2003 does not have any numerical suffix for the endpoint.

    So technically none of the answers are correct. 😛

    Technically speaking - What is SSRS 2003?:hehe:

  • RE: Report Server Web Service

    Hugo Kornelis (4/8/2010)


    Tom Garth (4/8/2010)


    I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.

    So is 2005 the endpoint's port number?

    You'll have to re-reread...

  • RE: Report Server Web Service

    I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.

    So is 2005 the endpoint's port number?

  • RE: Report Server Web Service

    Since I already knew that it was 2005 even with 2008 servers, I figured that 2006 was just a typo. So I got it right, and was surprised to see...

  • RE: ANSI_NULLS

    CirquedeSQLeil (4/7/2010)

    Which in turn will break one of Microsoft's own products - Dynamix / CRM

    I've worked with that for14 years, and I never noticed.

    Good explanation Paul.

  • RE: DBCC Timewarp

    john.arnott (4/2/2010)


    Tom Garth (4/2/2010)


    As I waited for my score, it hit me. Du-uh! 137 is the only non power of 2 answer. My heart sank as I prepared for the...

  • RE: DBCC Timewarp

    As I waited for my score, it hit me. Du-uh! 137 is the only non power of 2 answer. My heart sank as I prepared for the inevitable "Sorry -...

  • RE: Decoding the SQL Server Index Structure

    samir-424465 (4/1/2010)


    waste of time :doze:

    😛 There is nothing wasteful about putting a grin on your face first thing in the morning.

    The article was nothing short of excellent. My mouth...

  • RE: Resource Governor

    For as long as I've had the luxury of using Developer Edition, I'm beginning to dislike it because of questions like this - that I got WRONG. It's not a...

  • RE: Burnout

    In Alcoholics Anonymous participants recite a very powerful prayer called The Serenity Prayer.

    God grant me the serenity to accept the things I cannot change; courage to change the...

Viewing 15 posts - 46 through 60 (of 321 total)