Forum Replies Created

Viewing 15 posts - 13,636 through 13,650 (of 19,560 total)

  • RE: Is the MVP Worth It?

    Grant Fritchey (6/10/2010)

    Jeff Moden (6/9/2010)

    ...nor do they knock their MVP rings...

    Whoa! Hold on a sec... you got a ring? I didn't get a ring. If I had a ring 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

    June 10, 2010 at 8:11 am

    #1178622

  • RE: Who Wants to Lead the Community?

    Grant Fritchey (6/10/2010)

    Steve, I'd love to run, really. Not because I have some great ideas for where to take the organization but because I'm willing to get in there &...

    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 10, 2010 at 8:07 am

    #1178619

  • RE: Model DB

    stewartc-708166 (6/10/2010)

    Good question.

    I found the inconsistency with BOL interesting.

    Thanks

    Thanks

    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 10, 2010 at 8:02 am

    #1178614

  • RE: Who Wants to Lead the Community?

    chrisn-585491 (6/10/2010)

    my company doesn't believe in professional development

    ++

    PASS really doesn't do much for me and I can't even attend the conference. If I'm going to volunteer, I'd rather 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

    June 10, 2010 at 8:02 am

    #1178613

  • RE: Model DB

    Hugo Kornelis (6/10/2010)

    Interesting find, Jason. I missed my point because I believed Books Online. The only small critisism (sp?) I have on this question is the incorrect use of uppercase...

    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 10, 2010 at 8:00 am

    #1178612

  • RE: Advice for getting First SQL Job

    Two suggestions:

    Get SQL 2008 Developer Edition

    and

    Hand out in the forums here and try to solve some of the problems using Developer Edition. This will help you learn a lot...

    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 9, 2010 at 11:10 pm

    #1178435

  • RE: Alter command

    Jeff Moden (6/9/2010)

    CirquedeSQLeil (6/9/2010)

    Two options

    Create a cursor that does essentially the same thing I just showed you.

    or

    Run that script, review the commands, and then set it up in a job...

    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 9, 2010 at 10:50 pm

    #1178428

  • RE: Model DB

    malleswarareddy_m (6/9/2010)

    I put it newreadonly but still it allows to create a table. which is not possible with setting with tool. (database properties----readonly---true.)

    then create new db with wizard. It automatically...

    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 9, 2010 at 10:48 pm

    #1178426

  • RE: Who Wants to Lead the Community?

    I think volunteering is an excellent way to spend your time. Elections and Politics are a different Ball of wax. I would almost say that being 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

    June 9, 2010 at 10:44 pm

    #1178425

  • RE: Is the MVP Worth It?

    Jeff Moden (6/9/2010)

    ... it's nice to see hardworking folks be recognized and given a gift or two for their efforts even if they turn out to not be a "Ninja"...

    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 9, 2010 at 10:35 pm

    #1178419

  • RE: Today's Random Word!

    RBarryYoung (6/9/2010)

    CirquedeSQLeil (6/9/2010)

    Blowing your own horn again, Jason?

    😛

    Yup - they're blowing 'em in South Africa so I thought I would join in.

    It also looks like you took your turn blowing...

    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 9, 2010 at 10:32 pm

    #1178418

  • RE: get count from count query

    Thanks Wayne.

    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 9, 2010 at 10:29 pm

    #1178416

  • RE: Model DB

    UMG Developer (6/9/2010)

    Though the first option for script 4 should be updated to say NewReadOnlyDB instead of TestA.

    Steve, could you update that option? It is the answer option...

    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 9, 2010 at 10:24 pm

    #1178413

  • RE: Model DB

    malleswarareddy_m (6/9/2010)

    hi without the script i set the model database into read only.then i create the new database but i am not able to create the new table because 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

    June 9, 2010 at 10:22 pm

    #1178412

  • RE: Model DB

    Thanks. True - BOL does state that the MODEL DB cannot be set to ReadOnly, that's why I found this to be an interesting behavior.

    Thanks for pointing out 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 9, 2010 at 10:19 pm

    #1178410

Viewing 15 posts - 13,636 through 13,650 (of 19,560 total)