Forum Replies Created

Viewing 15 posts - 15,676 through 15,690 (of 19,560 total)

  • RE: DB movement from sql 2005 to sql 2005 but to a different server.

    homebrew01 (3/31/2010)

    For #2. Wouldn't they get restored as part of MSDB database restore ?

    It depends - stored in msdb or on filesystem.

    Same with #3

    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 31, 2010 at 2:43 pm

    #1143483

  • RE: The Missing Certification

    WayneS (3/31/2010)

    dma-669038 (3/31/2010)

    One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')

    Makes me wonder what he thinks the difference...

    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 31, 2010 at 2:27 pm

    #1143476

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/31/2010)

    Scared him off I think we did...

    I'm sure it did.

    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 31, 2010 at 2:26 pm

    #1143475

  • RE: The Missing Certification

    Lynn Pettis (3/31/2010)

    CirquedeSQLeil (3/31/2010)

    Jeff Moden (3/31/2010)

    Grant Fritchey (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know 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

    March 31, 2010 at 1:40 pm

    #1143442

  • RE: Are the posted questions getting worse?

    lmu92 (3/31/2010)

    I just try to imgaine how you change a tape the "frisbee-style" :hehe:

    With a crossbow.: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

    March 31, 2010 at 1:40 pm

    #1143441

  • RE: The Missing Certification

    Jeff Moden (3/31/2010)

    Grant Fritchey (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table...

    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 31, 2010 at 1:34 pm

    #1143432

  • RE: SQL Overview VI - Monitoring Process Locks

    Thanks for yet another nice article in this series.

    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 31, 2010 at 1:27 pm

    #1143427

  • RE: Are the posted questions getting worse?

    lmu92 (3/31/2010)

    I think question #6 cannot be answered on this forum at all:

    6 - how operators would move?

    The answer would depend on too many things, e.g.

    How much money is offered...

    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 31, 2010 at 1:26 pm

    #1143422

  • RE: An interesting thing about isnull

    Paul White NZ (3/31/2010)

    CirquedeSQLeil (3/31/2010)

    Adam Machanic summarizes his testing here.

    In the comments, Adam notes that there seems to be no difference in SQL Server 2008...

    My testing shows that any application...

    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 31, 2010 at 1:22 pm

    #1143419

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/31/2010)

    Hey Lynn,

    My average has improved to 98.67 posts per day.

    Night all 🙂

    See how you are - constantly trying to drive up the class average and distort 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

    March 31, 2010 at 1:16 pm

    #1143412

  • RE: The Missing Certification

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan and index seek...

    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 31, 2010 at 1:15 pm

    #1143411

  • RE: The Missing Certification

    Paul White NZ (3/31/2010)

    Lynn Pettis (3/31/2010)

    Or Certifiable

    Humph! :laugh:

    Most certainly certifiable.

    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 31, 2010 at 1:07 pm

    #1143403

  • RE: The Missing Certification

    Jeff Moden (3/31/2010)

    Maybe I've been spoiled by the likes of folks like the denizens of SSC but it sure does seem to me that the SQL Server IQ even on...

    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 31, 2010 at 1:00 pm

    #1143391

  • RE: The Missing Certification

    Jeff Moden (3/31/2010)

    CirquedeSQLeil (3/30/2010)

    Lynn Pettis (3/30/2010)

    Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we 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

    March 31, 2010 at 12:57 pm

    #1143387

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/31/2010)

    lmu92 (3/31/2010)

    But it's a while back since I've last seen a LMGTFY link...

    Seems like we're kinda learning search engine.

    How does a search engine express it's/his/her feelings anyway?

    Like this.

    Oh...

    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 31, 2010 at 12:55 pm

    #1143381

Viewing 15 posts - 15,676 through 15,690 (of 19,560 total)