Post reply

Are the posted questions getting worse?

  • March 18, 2010 at 3:23 pm

    #1136343

    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

  • March 18, 2010 at 3:30 pm

    #1136348

    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)
    Intro to Tally Tables and Functions

  • March 18, 2010 at 3:33 pm

    #1136351

    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

  • March 18, 2010 at 4:20 pm

    #1136362

    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

  • March 18, 2010 at 4:29 pm

    #1136368

    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

  • March 18, 2010 at 4:45 pm

    #1136374

    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

  • March 18, 2010 at 4:56 pm

    #1136381

    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

  • March 18, 2010 at 7:14 pm

    #1136403

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • March 18, 2010 at 8:52 pm

    #1136419

    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)
    Intro to Tally Tables and Functions

  • March 18, 2010 at 9:05 pm

    #1136423

    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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

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

  • March 18, 2010 at 9:09 pm

    #1136425

    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

  • March 18, 2010 at 9:14 pm

    #1136429

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

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

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

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

  • March 18, 2010 at 9:45 pm

    #1136432

    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

  • March 18, 2010 at 10:48 pm

    #1136439

    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...

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • March 18, 2010 at 10:53 pm

    #1136440

    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.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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