Forum Replies Created

Viewing 15 posts - 10,606 through 10,620 (of 11,678 total)

  • RE: Interview

    Craig Farrell (1/6/2011)


    3) What will you do if tempdb, transaction log file is full

    Best way to start that research is get yourself a small partition on a drive (usually your...

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/5/2011)


    Of course, if you really want to mess with your own head, you can always assume because of graph charts and the like that -infinity = infinity, and...

  • RE: Are the posted questions getting worse?

    GilaMonster (1/5/2011)


    Koen (da-zero) (1/5/2011)


    I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.

    However if you allow it, it's trivial...

  • RE: Temp db SIZE please

    AK1516 (1/5/2011)


    Hi folks,

    i am looking for the size of temp db an instance of sql server.Where the instance contains 1 TB of database in the prod environment

    Do you want to...

  • RE: BCP w/UNC path

    kevin_fralick (1/5/2011)


    Hi all,

    I'm trying to output a file from one server to another using BCP.

    It fails, I think, because the path contains space in 'Program Files'. I also tried...

  • RE: Are the posted questions getting worse?

    GSquared (1/5/2011)


    Brandie Tarvin (1/5/2011)


    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in...

  • RE: Are the posted questions getting worse?

    WayneS (1/5/2011)


    Brandie Tarvin (1/5/2011)


    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough...

  • RE: TRUNCATE in TRANSACTION

    And I thought I was already "old" because I have used floppy disks 😀

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/5/2011)


    Koen (da-zero) (1/5/2011)


    Definately a PBCAC programming error.

    (problem between chair and computer)

    I've always heard of it as a PEBKAC error. "Problem exists between keyboard and chair."

    That's possible. I was...

  • RE: Are the posted questions getting worse?

    GSquared (1/5/2011)


    Dave Ballantyne (1/4/2011)


    Had to share ... On facebook one of my wifes friends posts

    On drilling into C++ from C#, I know now why C# is so called "word safe":...

  • RE: The Execute SQL Task

    Daniel Bowlin (1/5/2011)


    ForceExecutionResult is a great little debugging tool/task property. Great question.

    Indeed. I was just realizing that this property is ideal for testing event handlers, transactions and checkpoints in...

  • RE: Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile

    thamilanga (1/5/2011)


    Problem sorted,

    I went to my services and set service MSSQLServerADHelper startup type to Automatic then changed logon as to Local System, and the installation went through without any issues

    Thanks

    Glad...

  • RE: The Execute SQL Task

    WayneS (1/5/2011)


    I'm a bit curious - when would you have a condition where you want the task to report as successfully completed when it actually failed?

    To play April Fools tricks...

  • RE: is null check in where clause

    GilaMonster (1/5/2011)


    Asking whether it's better to check the column or the parameter is like asking which is better, watermelon or tuna.

    Watermelon. Definately. 😎

  • RE: Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile

    Adiga (1/5/2011)


    @thamilanga,

    This should be a good starting point.

    Yes, I also found the reference Buck Woody provided in a MSDN thread, but the only thing this article is useful for is...

Viewing 15 posts - 10,606 through 10,620 (of 11,678 total)