Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 19,560 total)

  • RE: Today's Random Word!

    roach

    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, 2013 at 12:55 pm

    #1621470

  • RE: Are the posted questions getting worse?

    Sean Lange (6/5/2013)

    Jack Corbett (6/5/2013)

    SQLRNNR (6/5/2013)

    Sean Lange (6/5/2013)

    Jeff Moden (6/4/2013)

    Brandie Tarvin (6/4/2013)

    My Recovery Plan

    1) SCREAM really loudly so everyone knows there is a problem.

    2) Run out of 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, 2013 at 9:54 am

    #1621405

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/5/2013)

    Damn. Out-Ninja'd by Sean.

    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, 2013 at 9:53 am

    #1621404

  • RE: COALESCE

    Wow - talk about DBCC Timewarp and some wormhole effect.

    Reason being that the same question was for June 3 and June 8. Answer one and both get ticked 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

    June 5, 2013 at 9:37 am

    #1621389

  • RE: Usage of Null

    Danny Ocean (6/4/2013)

    Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to...

    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, 2013 at 9:34 am

    #1621385

  • RE: Are the posted questions getting worse?

    Sean Lange (6/5/2013)

    Jeff Moden (6/4/2013)

    Brandie Tarvin (6/4/2013)

    My Recovery Plan

    1) SCREAM really loudly so everyone knows there is a problem.

    2) Run out of the building as fast as possible.

    3) Update my...

    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, 2013 at 9:30 am

    #1621381

  • RE: Are the posted questions getting worse?

    Lowell (6/4/2013)

    GabyYYZ (6/4/2013)

    SQLRNNR (6/4/2013)

    GabyYYZ (6/4/2013)

    Back...what I miss?

    We are busy writing the DR plan for SSC and RedGate. Nothing big.

    Ahhh...in our company, we consider naivete and blissful ignorance as sound...

    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 4, 2013 at 12:18 pm

    #1621072

  • RE: Are the posted questions getting worse?

    GabyYYZ (6/4/2013)

    Back...what I miss?

    We are busy writing the DR plan for SSC and RedGate. Nothing big.

    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 4, 2013 at 11:32 am

    #1621061

  • RE: List of queries using MAXDOP

    SQLSACT (6/4/2013)

    If you're looking for queries that have previously executed with parallelism, have a look here

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

    Thanks for the info.

    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 4, 2013 at 9:30 am

    #1621021

  • RE: List of queries using MAXDOP

    hvermaak (6/4/2013)

    Hi

    Great Script. I was just wondering if there is a reason why the OBJName and DBName doesn't populate?

    That is a good question. I have seen this 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

    June 4, 2013 at 9:30 am

    #1621019

  • RE: Are the posted questions getting worse?

    rodjkidd (6/4/2013)

    "well it would be nice, but we've never had any problems so far"...

    They haven't had any problems that they may know about because people took care of the problems...

    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 4, 2013 at 9:24 am

    #1621015

  • RE: Are the posted questions getting worse?

    andrew gothard (6/4/2013)

    rodjkidd (6/4/2013)

    Just got off a conference call, and the subject of DR came up.

    The reply?

    "well it would be nice, but we've never had any problems so far"...

    I'm sure...

    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 4, 2013 at 9:21 am

    #1621013

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/3/2013)

    jcrawf02 (6/3/2013)

    Stefan Krzywicki (6/3/2013)

    The Dixie Flatline (6/3/2013)

    What does a MAX datatype do?

    Pulls a sled for the Grinch datatype

    Wow, 78 seconds (between posts) to come up with 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 3, 2013 at 2:47 pm

    #1620715

  • RE: Are the posted questions getting worse?

    Jeff Moden (5/31/2013)

    Grant Fritchey (5/31/2013)

    Jack Corbett (5/31/2013)

    Jack Corbett (5/31/2013)

    Have I mentioned these 2 things lately:

    1. I can't stand ORM tools and the queries they create

    2....

    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

    May 31, 2013 at 4:55 pm

    #1620246

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/31/2013)

    Have I mentioned these 2 things lately:

    1.

    2.

    Thanks,

    I think you better say it again.

    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

    May 31, 2013 at 1:56 pm

    #1620219

Viewing 15 posts - 4,516 through 4,530 (of 19,560 total)