Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    EL Jerry (8/15/2014)


    Ed Wagner (8/15/2014)


    Ed Wagner (8/13/2014)


    rodjkidd (8/13/2014)


    Ed and Jason,

    Some serious rain there. Glad to hear you are all OK.

    Rodders...

    Thanks for all the well wishes, everyone. Things are...

    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!

    disco

    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: Stored Procedure slower on faster newer machine ?

    destino (8/14/2014)


    I wondered about the power consumption of the keyboard, lots of flashing LEDS.;-)

    I took your advice and cranked up the power setting to "Performance" accepting the defaults for...

    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: Crazy VLF count growth 274 to 97482

    DennisPost (8/15/2014)


    Changing to 8000 instead of 8GB will most likely help.

    I'll will do that. But why? What is this based on?

    I have seen the same sort of thing. ...

    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: Which query will give an error?

    sestell1 (8/15/2014)


    XML... yuck. :sick: :laugh:

    +1

    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: Stored Procedure slower on faster newer machine ?

    First thing to check imho would be the power plan.

    Next would be to check the various server settings and verify they match the previous.

    And the list goes on from...

    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: Alerting when tempdb files have X% free space

    Disabling autogrowth is not a requirement.

    Size up your files in advance. Round Robin will work.

    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?

    TomThomson (8/14/2014)


    Ed Wagner (8/14/2014)


    Evil Kraig F (8/14/2014)


    djj (8/14/2014)


    ChrisM@Work (8/14/2014)

    remember '76/'77

    Wish I could remember what last year was like, I remember some nice days for '77 as I have 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: Today's Random Word!

    perspicacious

    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: sp_rename and the procedure definition

    TomThomson (8/14/2014)


    SQLRNNR (8/13/2014)


    TomThomson (8/13/2014)


    SQLRNNR (8/13/2014)


    Why can't sp_rename perform that same metadata update?

    Good question. That's something we definitely agree on. sp_rename should update all the metadata. If it...

    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: Alerting when tempdb files have X% free space

    Jay@Work (8/14/2014)


    Thanks Jeff.

    Have your tempDB files ever had to autogrow or were they created with an initial size large enough that this hasn't been necessary?

    Our Sharepoint consultants advised the 1...

    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: Table creation policies. Is this silly or is it just me?

    Sounds like a bit of a waste of time and somebody who decided to put his power to the test by creating a bunch of time wasting policy.

    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!

    Ed Wagner (8/14/2014)


    djj (8/14/2014)


    Ed Wagner (8/14/2014)


    whereisSQL? (8/14/2014)


    SQLRNNR (8/14/2014)


    Ed Wagner (8/14/2014)


    Sean Lange (8/14/2014)


    peanut butter

    Nutella

    creamy jar of deliciousness

    craving

    Steak

    Potato

    Fries

    back to steak already?

    ok then

    steak

    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?

    Eirikur Eiriksson (8/14/2014)


    Luis Cazares (8/14/2014)


    Grant Fritchey (8/14/2014)


    Evil Kraig F (8/14/2014)


    djj (8/14/2014)


    ChrisM@Work (8/14/2014)

    remember '76/'77

    Wish I could remember what last year was like, I remember some nice days for '77 as...

    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?

    Luis Cazares (8/14/2014)


    Grant Fritchey (8/14/2014)


    Evil Kraig F (8/14/2014)


    djj (8/14/2014)


    ChrisM@Work (8/14/2014)

    remember '76/'77

    Wish I could remember what last year was like, I remember some nice days for '77 as I have...

    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 - 2,221 through 2,235 (of 19,560 total)