DBCC Timewarp

  • Comments posted to this topic are about the item DBCC Timewarp

  • Man, that was a lot of points for this question!

    Happy April Fools!

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • The holidays are a good time to boost your score. We usually do something fun and simple.

  • Let's do the timewarp together!!!

    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

  • Awesome question!!!!!

    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

  • I'm a bit disappointed... no mention of the hampster poo enhancement. 😛

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

  • Jeff Moden (3/31/2010)


    I'm a bit disappointed... no mention of the hampster poo enhancement. 😛

    Or the optional parameters :hehe:

    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

  • Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D

    Even tried to google it and found nothing much. Though on a fluke got the answer right.

    SQL DBA.

  • SanjayAttray (3/31/2010)


    Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D

    Even tried to google it and found nothing much. Though on a fluke got the answer right.

    Congrats. It is extremely undocumented 😉

    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

  • heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)

    lucky to get 7 points.. 😛

  • ziangij (3/31/2010)


    heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)

    lucky to get 7 points.. 😛

    Congrats. I better go check out that editorial.

    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

  • As long as the DBCC TimeWarp thread has been out there, you'd think more people would be getting this question right. :w00t:

  • Lynn Pettis (3/31/2010)


    As long as the DBCC TimeWarp thread has been out there, you'd think more people would be getting this question right. :w00t:

    Mildly surprising. Only 42 respondents though.

    That is a really big clue though.

    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

  • Had not even heard about it...damn did some googling and got the points...I just dint want to lose 7 points !!...hehe.

    Thanks for teaching something new...!!

  • Joy Smith San (3/31/2010)


    Had not even heard about it...damn did some googling and got the points...I just dint want to lose 7 points !!...hehe.

    Thanks for teaching something new...!!

    Good job on finding the correct answer.

    I would go back and re-read the source though.

    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

Viewing 15 posts - 1 through 15 (of 53 total)

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