Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    Oh that would be too much fun. To culminate it, nobody would reveal it until the next day, buahahaha.

    -5 pts should be a great one - make the question...

    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

    March 12, 2010 at 3:50 pm

    #1133053

  • RE: need to find out what SQL is running

    profiler

    trace

    sp_who2 (if they are running it currently)

    those are a few options.

    Also check out the article from yesterday (I have used this in the past to do the same sort of...

    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

    March 12, 2010 at 3:43 pm

    #1133048

  • RE: Is it possible...

    One option would be to enable a logon trigger and capture the logon information out to a table with a datestamp.

    .

    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

    March 12, 2010 at 3:38 pm

    #1133045

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2010)

    Steve Jones - Editor (3/12/2010)

    I have a simple one, but if anyone wants to suggest one, feel free.

    I emailed you my question. Even though I had soemthing...

    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

    March 12, 2010 at 2:53 pm

    #1133024

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    Grant Fritchey (3/12/2010)

    And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is...

    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

    March 12, 2010 at 1:26 pm

    #1132990

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2010)

    And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the developer...

    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

    March 12, 2010 at 1:10 pm

    #1132972

  • RE: Friday Afternoon

    sing4you (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    sing4you (3/12/2010)

    We have yoga and t'ai chi classes here at work. Three lunch hours per week, I'm at one of those. I also get out 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

    March 12, 2010 at 12:42 pm

    #1132951

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2010)

    Q: How can you tell that your day will not go well?

    A: You picked a fight with Paul Randall.

    http://www.sqlservercentral.com/Forums/Topic881729-391-1.aspx

    Scintillating.

    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

    March 12, 2010 at 12:40 pm

    #1132950

  • RE: Are the posted questions getting worse?

    GSquared (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    GSquared (3/12/2010)

    If we did the "Delusionally Thinks He's a DBA" contest, there would certainly be a lot of competition for that one.

    But I think if we had 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

    March 12, 2010 at 12:23 pm

    #1132933

  • RE: SSMS 2008

    Paul White (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    Paul White (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.

    Jason...CTRL +...

    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

    March 12, 2010 at 12:14 pm

    #1132925

  • RE: Are the posted questions getting worse?

    GSquared (3/12/2010)

    If we did the "Delusionally Thinks He's a DBA" contest, there would certainly be a lot of competition for that one.

    But I think if we had a "Please God...

    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

    March 12, 2010 at 12:10 pm

    #1132923

  • RE: Attribute to identify system databases

    Steve Jones - Editor (3/12/2010)

    You have a good point, but I think you're coding around a very unlikely possibility. There is literally thousands of scripts, including system scripts in 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

    March 12, 2010 at 12:03 pm

    #1132916

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2010)

    I'm holding out for the Adequate DBA Competition. I'll be GREAT!

    Why not the Barely Meets Expectations DBA?

    Could you imagine the competition? :hehe:

    And yes, it's Brad's book on how...

    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

    March 12, 2010 at 11:58 am

    #1132911

  • RE: Separate Styles

    GSquared (3/12/2010)

    I'm working on a book on my experiences with learning how to DBA. It'll definitely be written to take this kind of thing into account.

    When do we get...

    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

    March 12, 2010 at 11:56 am

    #1132909

  • RE: E K M

    My vote would be for the Roach And Insect Deterrent. 😀

    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

    March 12, 2010 at 11:53 am

    #1132906

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