Forum Replies Created

Viewing 15 posts - 9,241 through 9,255 (of 19,560 total)

  • RE: model database stuck in restore state

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    Ninja's_RGR'us (7/28/2011)

    brown-415622 (7/28/2011)

    I ran both scripts and both completed successfully. It brought back the model database back online and was able to see

    views and tables after about 5...

    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

    July 28, 2011 at 11:35 am

    #1360372

  • RE: model database stuck in restore state

    Ninja's_RGR'us (7/28/2011)

    brown-415622 (7/28/2011)

    I ran both scripts and both completed successfully. It brought back the model database back online and was able to see

    views and tables after about 5 min 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

    July 28, 2011 at 11:28 am

    #1360368

  • RE: Locking/Blocking issues

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    I like the script. I think it would be a good idea to note on your blog how you created that script.;-)

    Sure 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

    July 28, 2011 at 11:13 am

    #1360354

  • RE: Locking/Blocking issues

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    I like the script. I think it would be a good idea to note on your blog how you created that script.;-)

    Sure it might help...

    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

    July 28, 2011 at 11:05 am

    #1360347

  • RE: Locking/Blocking issues

    Ninja's_RGR'us (7/28/2011)

    SQLRNNR (7/28/2011)

    I like the script. I think it would be a good idea to note on your blog how you created that script.;-)

    Sure it might help us build...

    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

    July 28, 2011 at 11:01 am

    #1360340

  • RE: Job runnning more than 2 days

    Ninja's_RGR'us (7/28/2011)

    Yup, thank the author (top comment).

    Don't want to take the credit when it's not mine ;-),

    Well, I'll have to thank Microsoft sometime for that script. I decided 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

    July 28, 2011 at 10:57 am

    #1360331

  • RE: Locking/Blocking issues

    I like the script. I think it would be a good idea to note on your blog how you created that script.;-)

    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

    July 28, 2011 at 10:55 am

    #1360330

  • RE: Job runnning more than 2 days

    Ninja's_RGR'us (7/28/2011)

    Yup, thank the author (top comment).

    Don't want to take the credit when it's not mine ;-),

    i'll have to do that.:w00t:

    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

    July 28, 2011 at 9:46 am

    #1360253

  • RE: You Can Telecommute

    Ninja's_RGR'us (7/28/2011)

    Michael Valentine Jones (7/28/2011)

    I have had people on my team that are full time work from home for the last 10 years, and I am happy with the situation.

    We...

    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

    July 28, 2011 at 9:45 am

    #1360251

  • RE: You Can Telecommute

    Jack Corbett (7/28/2011)

    lewisc (7/28/2011)

    I was part of a group that was allowed the privilege of working from home two days a week for the last few years, big savings...

    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

    July 28, 2011 at 9:44 am

    #1360250

  • RE: You Can Telecommute

    gdonufrio (7/28/2011)

    can you send me a list of articles the explain that telecommuting is a fair option?

    pleeease !

    gabriele

    Here's one

    http://inst.eecs.berkeley.edu/~eecsba1/sp97/reports/eecsba1d/report/telecommute.html

    And another

    http://www.smartplanet.com/blog/transportation/study-telecommuting-can-save-american-households-17-billion-per-year/221

    And another (this one is ammunition to help convince 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

    July 28, 2011 at 9:42 am

    #1360243

  • RE: You Can Telecommute

    Schadenfreude-Mei (7/28/2011)

    gdonufrio (7/28/2011)

    can you send me a list of articles the explain that telecommuting is a fair option?

    pleeease !

    gabriele

    Yes, I'd second that cause as it stands we havent got...

    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

    July 28, 2011 at 9:40 am

    #1360238

  • RE: You Can Telecommute

    cengland0 (7/28/2011)

    ...

    I'm salary and I do work from home. When I went into the office, I would work my normal 10 hour day and then go home. 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

    July 28, 2011 at 9:38 am

    #1360237

  • RE: Job runnning more than 2 days

    Ninja's_RGR'us (7/28/2011)

    Is it getting blocked?

    --http://sqlfrndz.com/2011/06/09/activity-monitor-script-to-find-head-blocker-sql-server-2005-2008-and-later/

    SELECT

    [Session ID] = s.session_id,

    [User Process] = CONVERT(CHAR(1), s.is_user_process),

    [Login] ...

    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

    July 28, 2011 at 9:32 am

    #1360232

  • RE: Today's Random Word!

    Revenant (7/28/2011)

    crookj (7/28/2011)

    Brandie Tarvin (7/28/2011)

    Daniel Bowlin (7/28/2011)

    Same source, different subject:

    This bird is most definitely dead.

    No. No, it's not. It's just sleeping.

    JABBERWOCKY?

    he he......

    Dodo

    L'Isle Maurice

    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

    July 28, 2011 at 9:31 am

    #1360231

Viewing 15 posts - 9,241 through 9,255 (of 19,560 total)