Forum Replies Created

Viewing 15 posts - 15,466 through 15,480 (of 19,560 total)

  • RE: The Missing Certification

    Lynn Pettis (4/2/2010)

    Regarding Time in Service, I stay away from trying get into too much detail regarding how much time was spent writing stored procedures or triggers or view, 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

    April 2, 2010 at 11:49 am

    #1144996

  • RE: The Missing Certification

    Jack Corbett (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    A side note is that I have notified a member of the PASS board about this thread, they are excited about it, and may be weighing in...

    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

    April 2, 2010 at 11:35 am

    #1144987

  • RE: Are the posted questions getting worse?

    Trey Staker (4/2/2010)

    Paul White NZ (4/2/2010)

    Lynn Pettis (4/2/2010)

    I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through...

    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

    April 2, 2010 at 11:33 am

    #1144986

  • RE: Don't forget this date.

    Paul White NZ (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    Surprised it hasn't happened yet.

    vk-kirov covered it!

    I found that comment funny.

    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

    April 2, 2010 at 11:33 am

    #1144985

  • RE: Speed up a database shrink

    Paul White NZ (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    You could do it that way, or you could setup the replication with the snapshot and filters to get what you need. You would recreate...

    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

    April 2, 2010 at 11:32 am

    #1144984

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/2/2010)

    Lynn Pettis (4/2/2010)

    I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through Friday.

    Had 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

    April 2, 2010 at 11:30 am

    #1144982

  • RE: The Missing Certification

    Lynn Pettis (4/2/2010)

    I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

    Recertification should include testing, presenting original material at users groups/conferences, attending appropriate conferences...

    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

    April 2, 2010 at 11:27 am

    #1144980

  • RE: The Missing Certification

    Lynn Pettis (4/2/2010)

    As I thought about the labs, even if Microsoft actually hosts the MCJ testing systems, these would probably be best accessed from certified testing centers to help reduce...

    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

    April 2, 2010 at 11:25 am

    #1144976

  • RE: The Missing Certification

    Lynn Pettis (4/2/2010)

    Steve Jones - Editor (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    Lynn Pettis (4/2/2010)

    If you spend 50% of your time coding, what were you doing with the other 50%? There is more than...

    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

    April 2, 2010 at 11:23 am

    #1144974

  • RE: The Missing Certification

    Jack Corbett (4/2/2010)

    I believe that this lends greater weight to the certification. It won't stop unethical people from being certified but should help limit them.

    With a number of limiting...

    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

    April 2, 2010 at 11:21 am

    #1144972

  • RE: The Missing Certification

    Steve Jones - Editor (4/2/2010)

    I do think we need to have automated test. I'd be in favor of a VM that is set to some base and we ask for...

    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

    April 2, 2010 at 11:17 am

    #1144969

  • RE: The Missing Certification

    WayneS (4/2/2010)

    Kit G (4/2/2010)

    Just a note on requiring Time in Service. What are you going to do if the company that the person was working for goes out 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

    April 2, 2010 at 11:12 am

    #1144968

  • RE: Speed up a database shrink

    Chad Crawford (4/2/2010)

    TheSQLGuru (4/2/2010)

    2) script and drop ALL indexes if you are deleting 85% of the data. Do the deletes, shrink database, grow data file back out manually,...

    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

    April 2, 2010 at 11:10 am

    #1144965

  • RE: Don't forget this date.

    Voitek (4/2/2010)

    I did a cast(0 as datetime), but then I thought hmm. can negatives be converted to datetime? I picked 64000, but that failed, so then I went incrementally 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

    April 2, 2010 at 11:09 am

    #1144962

  • RE: Don't forget this date.

    Nice question.

    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

    April 2, 2010 at 11:08 am

    #1144961

Viewing 15 posts - 15,466 through 15,480 (of 19,560 total)