DBCC Timewarp

  • Did this thread disappear from the forum listing? I couldn't find it without having done a search.

    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

  • Maybe you warped back to a time before it existed???

    -- You can't be late until you show up.

  • tosscrosby (4/15/2010)


    Maybe you warped back to a time before it existed???

    I did - but thanks to the search being Timewarp compatible, I was able to find it, bring it back to the top of the queue and post.:w00t::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

  • DAMMIT!!    I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!

    Does anyone still follow this thread, and if so, can you give me directions on how to get back to 2010?

    __________________________________________________

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

  • The Dixie Flatline wrote:

    DAMMIT!!    I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!

    Does anyone still follow this thread, and if so, can you give me directions on how to get back to 2010?

    Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your right foot tucked behind your left ear with your left hand over your heart while swinging a pit bull by it's left leg counter clock-wise over your head while singing the 3rd verse of the Ghost-Busters theme song until the run completes.

    --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 wrote:

    The Dixie Flatline wrote:

    DAMMIT!!    I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!

    Does anyone still follow this thread, and if so, can you give me directions on how to get back to 2010?

    Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your right foot tucked behind your left ear with your left hand over your heart while swinging a pit bull by it's left leg counter clock-wise over your head while singing the 3rd verse of the Ghost-Busters theme song until the run completes.

    LMAO so funny Jeff 😂

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Jeff Moden wrote:

    Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your right foot tucked behind your left ear with your left hand over your heart while swinging a pit bull by it's left leg counter clock-wise over your head while singing the 3rd verse of the Ghost-Busters theme song until the run completes.

    This would be my new avatar!

    Does this pit bull have only two legs?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • The one I'm looking at has 3 legs and a pink bowtie around its neck. So I must be a little behind you, Phil.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Phil Parkin wrote:

    Jeff Moden wrote:

    Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your right foot tucked behind your left ear with your left hand over your heart while swinging a pit bull by it's left leg counter clock-wise over your head while singing the 3rd verse of the Ghost-Busters theme song until the run completes.

    This would be my new avatar!

    Does this pit bull have only two legs?

    It takes twice as long to run if that's the case.

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

Viewing 9 posts - 151 through 158 (of 158 total)

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