Forum Replies Created

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

  • RE: Today's Random Word!

    RBarryYoung (4/10/2010)


    (Heisenbergian sarcasm mode on)

    How have I missed this ontological wonder of a thread ... ?

    (Heisenbergian sarcasm mode off)

    Or is is epistemological? I always get them mixed up...

  • RE: Today's Random Word!

    Someone please tell me that this is not how Paul knocked out 3000 points in one month. I had ***-umed he was just racking up all of the QotDs...

  • RE: Today's Random Word!

    (Heisenbergian sarcasm mode on)

    How have I missed this ontological wonder of a thread ... ?

    (Heisenbergian sarcasm mode off)

  • RE: Today's Random Word!

    WTF?

  • RE: mis-appying a cross apply table value function?

    Paul White NZ (4/9/2010)


    Dave Ballantyne (4/9/2010)


    Hmmm

    Removing the Ip calculation and just setting it to zero , brings the run time crashing down to 600 - 700 ms..

    The in-line version ends...

  • RE: ANSI_NULLS

    Tom.Thomson (4/8/2010)


    Hugo Kornelis (4/8/2010)


    CirquedeSQLeil (4/8/2010)Is 0/0 = 1 or is 0/0 an error?

    To that question, my answer is a clear and resounding "yes"! 😛

    And mine is a resounding "sometimes"! Unless...

  • RE: Avg. disk Queue Length intermittently runs 100%, Looks like SQL Agent

    Disk queue lengths aren't measured or reported in percents? Busy% and Idle% are, but not queue lengths, so I can't tell what your actual queue lengths were?

  • RE: Splitting a single row into 2

    hmink 90250 (4/8/2010)


    I was unaware that you could get a pivot table to return text instead of numeric data... if that is possible, then that would be easy, and...

  • RE: Splitting a single row into 2

    hmink 90250 (4/8/2010)


    ...As you can imagine, if data is loaded for 22,000 partcodes and 15 facilities, this table get very large, very quick and you end up with a table...

  • RE: Splitting a single row into 2

    There's a lot of options and different ways to handle this in Excel, or in conjunction with both Excel and SQL Server. For instance many folks find that using...

  • RE: Splitting a single row into 2

    Excel has much better formatting capabilities than SQL Server, so you should probably be looking at this as an Excel reporting problem.

  • RE: How do I delete the SQL Server Configuration Manager?

    If you uninstall SQL Server, that should remove it.

    I am not sure if there is any other supported way to do this, why do you think that you need to...

  • RE: Databse mail sending blank mails

    Add the command "EXEC(@sql_query);" right before your send_dbmail. Then make sure that the job step is logging all of its output to a table or file and run it...

  • RE: ANSI_NULLS

    RBarryYoung (4/8/2010)


    Tom.Thomson (4/8/2010)


    RBarryYoung (4/7/2010)


    Paul White NZ (4/7/2010)


    RBarryYoung (4/7/2010)


    Yup, AFAIK SQRT, LOG and maybe POWER are the only things that return this error.

    Ooo - I had never tried POWER. Have...

  • RE: ANSI_NULLS

    CirquedeSQLeil (4/8/2010)


    RBarryYoung (4/8/2010)


    Tom.Thomson (4/8/2010)


    RBarryYoung (4/7/2010)


    Paul White NZ (4/7/2010)


    RBarryYoung (4/7/2010)


    Yup, AFAIK SQRT, LOG and maybe POWER are the only things that return this error.

    Ooo - I had never tried POWER. ...

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