Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    jasona.work (6/16/2015)


    So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012...

    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!

    DonlSimpson (6/5/2015)






    Empire

    Queensryche

    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: DBCC and disabled indexes

    While the question is good, I would rather have seen it say CHECKDB in lieu of DBCC on the correct answer (or in the explanation). Better still would 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

  • RE: Are the posted questions getting worse?

    andrew gothard (6/12/2015)


    Luis Cazares (6/12/2015)


    Lynn Pettis (6/12/2015)


    Alvin Ramard (6/12/2015)


    Lynn Pettis (6/12/2015)


    Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo...

    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 (6/12/2015)


    Lynn Pettis (6/12/2015)


    Alvin Ramard (6/12/2015)


    Lynn Pettis (6/12/2015)


    Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo 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: Are the posted questions getting worse?

    Grant Fritchey (6/9/2015)


    GilaMonster (6/9/2015)


    Grant Fritchey (6/9/2015)


    So tempted to whip out "DO YOU KNOW WHO I AM?"

    Need a hand somewhere?

    Nah, just a break. It actually wasn't a big deal. I'm glad...

    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?

    Grant Fritchey (6/9/2015)


    So tempted to whip out "DO YOU KNOW WHO I AM?"

    Time to walk away from the forums for a few...

    Where the **** is that tent?

    Well, I don't. ...

    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 (6/5/2015)


    BL0B_EATER (6/5/2015)


    SQLRNNR (6/5/2015)


    Eirikur Eiriksson (6/3/2015)


    Ed Wagner (6/3/2015)


    Eirikur Eiriksson (6/3/2015)


    SQLRNNR (6/3/2015)


    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    tube

    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?

    WayneS (6/5/2015)


    Jeff Moden (6/4/2015)


    Shifting gears a bit...

    Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a 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: Today's Random Word!

    Eirikur Eiriksson (6/3/2015)


    Ed Wagner (6/3/2015)


    Eirikur Eiriksson (6/3/2015)


    SQLRNNR (6/3/2015)


    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    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: Default Constraint Script

    Koen Verbeeck (6/5/2015)


    SQLRNNR (6/4/2015)


    Not really a fan of this particular question.

    Different patch levels - especially in 2014 - can cause different results. SSMS is extremely buggy in 2014.

    On 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: Filtered Indexes 2

    Good question. I had to think for a moment about the implicit conversion that could possibly happen depending on how the columns were defined (gender and username). But that didn't...

    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: Default Constraint Script

    Not really a fan of this particular question.

    Different patch levels - especially in 2014 - can cause different results. SSMS is extremely buggy in 2014.

    On the other hand, SQL...

    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: Log growth

    ramana3327 (6/4/2015)


    I think extended events are available in enterprise edition only. We are using standard

    Others have answered the edition question already.

    Is your version of SQL Server 2008, 2008R2, 2012, 2014...

    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: Log growth

    Grant Fritchey (6/4/2015)


    Not way after the fact, no. Even immediately following the event it may be hard to know why it happened. You'd be better off setting up monitoring through...

    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 - 1,231 through 1,245 (of 19,560 total)