Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 19,560 total)

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (6/5/2014)

    It took a couple weeks of data analysis and collection but I was finally able to prove that it was all because of dirty reads. We then started...

    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

    June 5, 2014 at 10:45 am

    #1719341

  • RE: Are the posted questions getting worse?

    TomThomson (6/5/2014)

    SQLRNNR (6/5/2014)

    Grant Fritchey (6/5/2014)

    Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where...

    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

    June 5, 2014 at 10:38 am

    #1719339

  • RE: Deadlock seems to involve only one object.

    Is this of any help?

    http://sqlperformance.com/2013/11/t-sql-queries/single-tx-deadlock

    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

    June 5, 2014 at 10:30 am

    #1719333

  • RE: Just curious, what are your SQL pet peeves ?

    george sibbald (6/5/2014)

    TheSQLGuru (6/5/2014)

    george sibbald (6/5/2014)

    I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

    Is Dynamics AX a microsoft...

    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

    June 5, 2014 at 10:27 am

    #1719332

  • RE: Just curious, what are your SQL pet peeves ?

    SQL is delicious (6/5/2014)

    LOL...because I questioned some of their coding practices and brought to light the fact that they're not following our standards when they promised they were, 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

    June 5, 2014 at 10:13 am

    #1719327

  • RE: MAXDOP

    david.alcock (6/5/2014)

    Thanks for the replies guys.

    No CXPACKET waits whatsoever, tiny little IO waits but that is about all. Its not the first time I have come across 'best' practices...

    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

    June 5, 2014 at 9:58 am

    #1719317

  • RE: Just curious, what are your SQL pet peeves ?

    hisakimatama (6/5/2014)

    Argh. I too suffer under the burden of working with code littered with NOLOCK :(.

    The vendor software

    ...

    "It's vital to our operations!", and that was that. ...

    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

    June 5, 2014 at 9:39 am

    #1719303

  • RE: Are the posted questions getting worse?

    Looks like SSC might have a PHP compromise.

    Various pages try to download a junk php file to my machine now. It started just yesterday.

    Who do we contact about that?

    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

    June 5, 2014 at 8:54 am

    #1719273

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/5/2014)

    SQLRNNR (6/5/2014)

    Grant Fritchey (6/5/2014)

    Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem,...

    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

    June 5, 2014 at 8:52 am

    #1719271

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/5/2014)

    Grant Fritchey (6/5/2014)

    Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where...

    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

    June 5, 2014 at 8:43 am

    #1719262

  • RE: Just curious, what are your SQL pet peeves ?

    SQL is delicious (6/5/2014)

    SQLRNNR (6/5/2014)

    Great. I love that excuse "It's the way we/I have always done it".

    That kind of excuse right there shows a base incompetence. Everything he...

    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

    June 5, 2014 at 8:39 am

    #1719261

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/5/2014)

    Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I),...

    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

    June 5, 2014 at 8:27 am

    #1719254

  • RE: Just curious, what are your SQL pet peeves ?

    SQL is delicious (6/5/2014)

    Koen Verbeeck (6/5/2014)

    SQL is delicious (6/5/2014)

    On the subject of WITH (NOLOCK) in code being a pet peeve....

    I was going over an SSIS template with a consultant 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

    June 5, 2014 at 8:10 am

    #1719245

  • RE: Today's Random Word!

    trotsalot

    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

    June 5, 2014 at 8:01 am

    #1719241

  • RE: Just curious, what are your SQL pet peeves ?

    GilaMonster (6/5/2014)

    Koen Verbeeck (6/5/2014)

    GilaMonster (6/5/2014)

    thomashohner (6/5/2014)

    What is the preference on column aliases ?

    AS. Equals sign is for comparing values or assigning values. 😀

    Yes, you assign the result of the expression...

    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

    June 5, 2014 at 7:38 am

    #1719219

Viewing 15 posts - 2,881 through 2,895 (of 19,560 total)