Forum Replies Created

Viewing 15 posts - 17,161 through 17,175 (of 19,560 total)

  • RE: How to get the password for User 'Sa'

    Thanks for posting back. Good to know it is working now.

    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

    February 18, 2010 at 10:46 am

    #1121118

  • RE: Today's Random Word!

    duct tape (pronounced duck tape 😀 )

    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

    February 18, 2010 at 10:38 am

    #1121110

  • RE: Are the posted questions getting worse?

    What was that Gail, you were coming in a bit fuzzy.

    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

    February 18, 2010 at 9:50 am

    #1121050

  • RE: Things to look for when planning for PASS 2010

    Thanks Grant.

    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

    February 18, 2010 at 9:48 am

    #1121046

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/18/2010)

    Paul White (2/18/2010)

    Grant Fritchey (2/18/2010)

    I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must...

    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

    February 18, 2010 at 9:45 am

    #1121039

  • RE: Are the posted questions getting worse?

    Paul White (2/18/2010)

    I got the checksum question wrong by the way - fell into the 'single bit error' bear trap 😎

    I used Paul's blog on the topic. He had...

    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

    February 18, 2010 at 9:36 am

    #1121027

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)

    Yes, i can connect using SSMS. However in object explorer details i see only database names i don't see any details for these databases.

    This seems different from the posted...

    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

    February 18, 2010 at 9:31 am

    #1121018

  • RE: How to get the password for User 'Sa'

    Would you mind divulging how you solved 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

    February 17, 2010 at 10:54 pm

    #1120670

  • RE: Emergency!!!!!!!! Production Databases

    Any errors in event logs?

    What has changed on the server? Did somebody try to install something recently?

    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

    February 17, 2010 at 10:44 pm

    #1120666

  • RE: How to get the password for User 'Sa'

    Is this your local desktop? Or is it a server that is used by several people?

    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

    February 17, 2010 at 10:39 pm

    #1120664

  • RE: LOCK

    Steve Jones - Editor (2/17/2010)

    Edited. I'll clean up points in the am.

    That was quick.

    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

    February 17, 2010 at 10:27 pm

    #1120661

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (2/17/2010)

    I have no idea what the pwd is, and don't want to know. It's someone else's responsibility.

    I am thinking of setting up a recurring snapshot each...

    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

    February 17, 2010 at 10:25 pm

    #1120660

  • RE: Are the posted questions getting worse?

    Paul, the QOD does need a slight modification in verbiage.

    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

    February 17, 2010 at 10:16 pm

    #1120650

  • RE: LOCK

    Paul White (2/17/2010)

    With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)

    What???!!! :w00t:

    I want my point back!

    Unless someone can...

    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

    February 17, 2010 at 10:11 pm

    #1120646

  • RE: Are the posted questions getting worse?

    Paul White (2/17/2010)

    Thank you both for those excellent suggestions - I will investigate and report back 😀

    SET RANT ON;

    Today's QOD ('LOCK') is just plain wrong!

    SET RANT OFF;

    Uh oh

    I guess it's...

    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

    February 17, 2010 at 9:50 pm

    #1120640

Viewing 15 posts - 17,161 through 17,175 (of 19,560 total)