DBCC Timewarp
-
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 -
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.
-
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."
-
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]
-
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."
-
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....
-
It's just a jump to the left. And then a step to the right. 😛
Converting oxygen into carbon dioxide, since 1955. -
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] -
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]
-
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 -
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. -
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]
-
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. 😀
-
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 -
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
Viewing 15 posts - 106 through 120 (of 152 total)
You must be logged in to reply to this topic. Login to reply