DBCC Timewarp

Question

DBCC Timewarp

Viewing 15 posts - 106 through 120 (of 158 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

or a surrogate (reference movie)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

CirquedeSQLeil (2/10/2010)
or a surrogate (reference movie)

Haven't seen that movie yet, but I have enjoyed the series Dollhouse. Too bad it is ending (or should I say ended) early.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 3

Lynn Pettis (2/10/2010)
CirquedeSQLeil (2/10/2010)
or a surrogate (reference movie)
Haven't seen that movie yet, but I have enjoyed the series Dollhouse. Too bad it is ending (or should I say ended) early.

Surely this thread can help with that issue?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

Steve Jones - Editor (2/10/2010)
Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?

No need to send them that far. December 22nd, 2012, should suffice. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 5

Alvin Ramard (2/10/2010)
Steve Jones - Editor (2/10/2010)
Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?
No need to send them that far. December 22nd, 2012, should suffice. 😀

Unless they're Jon Cusack.

... worst. last. line. ever.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

jcrawf02 (2/10/2010)
Lynn Pettis (2/10/2010)
CirquedeSQLeil (2/10/2010)
or a surrogate (reference movie)
Haven't seen that movie yet, but I have enjoyed the series Dollhouse. Too bad it is ending (or should I say ended) early.
Surely this thread can help with that issue?

Why not? Restore the databases, change the data to support keeping the series for its full 5 year planned run. Perfect use of the DBCC Timewarp command. Now, if I can just figure out the right optional parameters to restore an unknown database backup to an unknow server....

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 7

It's just a jump to the left. And then a step to the right. 😛

Converting oxygen into carbon dioxide, since 1955.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛

Put your hands on your hips?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 9

RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?

Yes.

Raise your right foot. .... Now raise your left foot. ..... NO!! Don't put your right foot down!!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?

And shake 'em all about.

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

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 11

RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?

...and pull your knees in tight.

Converting oxygen into carbon dioxide, since 1955.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

Steve Cullen (2/16/2010)
RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?
...and pull your knees in tight.

It's time to levitate!!!!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 13

Alvin Ramard (2/16/2010)
RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?
Yes.
Raise your right foot. .... Now raise your left foot. ..... NO!! Don't put your right foot down!!

...since you just decided to take a break by resting on the floor it's time for a little exercise:

With both arms: move your left(/right) arm under your (raised) left(/right) leg and put your left(/right) hand on your right(/left) shoulder. Relax.

Cross your feeds behind your neck. For untrained people: you may take one hand off your shoulder for a moment to support the movement of your feets.

Relax and enjoy!

And stay tuned for our upcoming show next week where we'll show you how to resolve the Gordian knot. 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 14

To the ill-illuminated:

The "jump to the left" quote is from a song in the movie "Rocky Horror Picture Show, which is a fictionalized version of the last days of Dr. Frank N. Furter, the under-acclaimed Transylvanian genius who is rumored to have been the actual coder of DBCC TIMEWARP, despite the so-far unchallenged claim to authorship made by Gail Shaw.

A dance step called the TIMEWARP features prominently in the film. The basic steps are posted below, but I was unable to locate a hologram that would properly illustrate the absolutely essential pelvic thrust.

http://images.cafepress.com/image/26173560_400x400.jpg%5B/img%5D

__________________________________________________

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Alvin Ramard (2/16/2010)
Steve Cullen (2/16/2010)
RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛
Put your hands on your hips?
...and pull your knees in tight.
It's time to levitate!!!!

alleviate

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