Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 19,560 total)

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    There are good reasons that it comes disabled by default.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Uninstall SQL Server 2008 SSIS Service

    Have you tried to uninstall via add/remove programs or SQL Setup?

    Do you get an error message?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    How are things going for the All Blacks and SpringBok?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/5/2011)


    Steve Jones - SSC Editor (10/5/2011)


    instance time v os time? Sheesh, is there a technical discussion taking place again?

    Perhaps, but it is in the guise of a smartass...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Create Stored Procedure - can't end it

    As Remi did, a little indentation (formatting) goes a long way to helping resolve little problems like what you were experiencing.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    GilaMonster (10/5/2011)


    You get a difference because the query adds the milliseconds since the computer started to the time that SQL started. So if SQL Server started 27 seconds after the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    SQL Kiwi (10/5/2011)


    SQLRNNR (10/5/2011)


    2 of 3 servers I get arithmetic overflow and the 3rd server differs by 35 seconds.

    Yeah great, so do I come back for the second interview or...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    SQL Kiwi (10/5/2011)


    Jan Van der Eecken (10/5/2011)


    Cool, but when I run this and also select GETDATE() on one of my servers, the two returned values differ by about 27 seconds....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Syntax Error

    bkubicek (10/5/2011)


    JimS-Indy (10/5/2011)


    I just can't identify the syntax error in the last line here (WHERE clause) Can anyone help?

    INSERT INTO tblBoMDetail

    (BoMID,

    BoMItemDescription,

    BoMEItemQty,

    BoMEItemfactor,

    BoMEItemUOM,

    BoMItemUnitMaterialCost,

    BoMItemUnitLaborHrs,

    BoMlaborComplexity,

    BoMvendorName,

    BoMvendorPartNbr,

    BoMItemID)...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Syntax Error

    Rather than a select * in each of the subqueries, identify the specific columns and make sure the columns are aliased appropriately if necessary.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

    "Aren't ya glad we didn't step in it?"

    No-Prize for guessing the source....

    Smells like

    Looks Like

    Tastes like

    And we have a winner!

    Beach and...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

    "Aren't ya glad we didn't step in it?"

    No-Prize for guessing the source....

    Smells like

    Looks Like

    Tastes like

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: How to verify the VLF is active or inactive?

    Perry Whittle (10/5/2011)


    SQLRNNR (10/4/2011)


    For more info check the links in my sig for Kimberly Tripp.

    Hmm, it is a good article, although I don't agree with Kimberleys statement that detaching a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Chad Crawford (10/5/2011)


    Stefan Krzywicki (10/5/2011)


    Jeff Moden (10/5/2011)


    Ninja's_RGR'us (10/5/2011)


    Jeff Moden (10/4/2011)


    GilaMonster (10/4/2011)


    Jeff Moden (10/4/2011)


    I wonder how many of us there are that try to completely ignore certs and degrees in...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 8,386 through 8,400 (of 19,560 total)