Are the posted questions getting worse?

  • Jack Corbett (3/18/2010)


    For those not on twitter. I took and passed 70-450 today.

    It was definitely harder than 70-432, but common sense gets you through it. There isn't a training kit for it, so I basically read up on my worst topics in BOL.

    Congrats!!!!:-)

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • David Burrows (3/18/2010)


    BWAAAHAAA....

    TWANG......

    Hmmmmm... the possible makings of new T-Shirt.:-P

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jack Corbett (3/18/2010)


    For those not on twitter. I took and passed 70-450 today.

    It was definitely harder than 70-432, but common sense gets you through it. There isn't a training kit for it, so I basically read up on my worst topics in BOL.

    Congrats

    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

  • Way to go, Unc.... 😀

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • Now it's everybody else's turn 😀

    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

  • Late last night I saw a question but didn't respond to it because I was shutting down in the intent of answering it today.

    I can't find it anymore.

    Anybody see a question asking how to differentiate between Editions of SQL Server (i think he stated MSDE and Enterprise and provided some version numbers)?

    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

  • Nevermind - I finally found 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

  • john.arnott (3/18/2010)


    Lynn Pettis (3/17/2010)


    Like clustered indexes are better than nonclustered indexes?

    Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could you make all our indexes clustered, please?". (I only think about it.)

    Actually, back in 1997, I was able to create two clustered indexes on a table in a Sybase database. The table didn't survive the operation, but the operation was a success.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • GSquared (3/18/2010)


    john.arnott (3/18/2010)


    Lynn Pettis (3/17/2010)


    Like clustered indexes are better than nonclustered indexes?

    Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could you make all our indexes clustered, please?". (I only think about it.)

    Sure. That one's easy. Just means every table can only have one index, but it can be done. 🙂

    BWAA-HAAA!!!! If you put everything into a single EAV, you CAN have a clustered index on all the data in the database. :hehe::-D

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • GSquared (3/18/2010)


    john.arnott (3/18/2010)


    Lynn Pettis (3/17/2010)


    Like clustered indexes are better than nonclustered indexes?

    Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could you make all our indexes clustered, please?". (I only think about it.)

    Sure. That one's easy. Just means every table can only have one index, but it can be done. 🙂

    Actually, there is a way this can be done - maybe.

    For each index, create an indexed view covering the columns in the index. Of course, once that is done - just try making a change to the table. See how long it takes you to drop all of the views - and indexes, update the table and rebuild all of the views.

    Could be lots of fun :hehe:

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey Williams-493691 (3/18/2010)


    Could be lots of fun :hehe:

    In a sinisterly maniacal way.:sick:

    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

  • CirquedeSQLeil (3/18/2010)In a sinisterly maniacal way.:sick:

    Yes - but that is what would be so much fun 😀

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey Williams-493691 (3/18/2010)


    CirquedeSQLeil (3/18/2010)In a sinisterly maniacal way.:sick:

    Yes - but that is what would be so much fun 😀

    Passing it off to the Junior and watching the Jr try to do it. That would be insanely fun.:-D

    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

  • David Burrows (3/18/2010)


    It's that recurring nightmare of Jeff creeping up on me with a Pork Chop Launcher......

    BWAAAHAAA....

    TWANG......

    Powerful mental image there...

  • CirquedeSQLeil (3/18/2010)


    I am curious why you changed your alias to include NZ.

    Several reasons, mostly consistency. I am registered with that name on other forum-type sites, and it matches my email address. It also gives people a clue that I may not share their time zone.

Viewing 15 posts - 12,976 through 12,990 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply