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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 14, 2010 at 7:50 am

    #1151348

  • 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?...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 12, 2010 at 6:00 am

    #1149948

  • RE: Understanding and Using APPLY (Part 1)

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

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 12, 2010 at 5:54 am

    #1149943

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 9, 2010 at 12:42 pm

    #1149314

  • RE: Security

    Steve Cullen (4/9/2010)

    Sometimes it pays to guess. 😀

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

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 9, 2010 at 12:13 pm

    #1149305

  • 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:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 9, 2010 at 7:10 am

    #1149058

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 8, 2010 at 7:28 am

    #1148259

  • 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?

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 8, 2010 at 7:01 am

    #1148231

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 8, 2010 at 6:57 am

    #1148224

  • 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.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 7, 2010 at 11:51 am

    #1147630

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 2, 2010 at 11:44 am

    #1144991

  • 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 -...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 2, 2010 at 8:36 am

    #1144798

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 1, 2010 at 7:39 am

    #1143964

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 30, 2010 at 8:15 am

    #1142239

  • 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...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 25, 2010 at 7:04 am

    #1139590

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