DBCC Timewarp
-
RBarryYoung (2/9/2010)
Bob Hovious (2/9/2010)
The Dixie Flatline (2/8/2010)
Oh sweet mercy..... Barry is really my own self from an alternative universe?!I feel smarter already !!
Crap! My wife just called me "Bob"! That's not right, ... is it? OMG, I can't remember what my real name is supposed to be anymore!!! Please, somebody send help fast! ... :crazy:
Oh no! Oh no, oh no, ... Look what just appeared on my shoulder:
Why would you do this to yourself, Bob?!?! GAAAAAHHHH!!!!
Whew! I figured out how to fix it, so it's all better now. Wow, am I glad that's over. Though that tatoo is taking its time going away ...
[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 (2/9/2010)
GSquared (2/9/2010)
Lowell (2/8/2010)
you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:somehow I've forgotten to create any backups on the production database for the last two years. Now the boss wants to archive all the backups off site for disaster recovery.
Based on your wonderful examples, I was able to create a backup today based on a backup i was planning to do in a week or two after I got back from vacation; but now i need to create a history of backups that go BACK two years, so it looks like I was doing my job.
Can anyone help me with the syntax for that?
Just type it all in backwards. Works every time.
... but don't run it backwards, or else your backups will become restores, and your restores backups.
... and everything will turn to Hampster poo which means that if bit #2 (appropriately numbered, I may add) is set, the system will regenerate itself... except maybe for the Elderberries.
--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) -
CirquedeSQLeil (2/9/2010)
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.Expert? Yeah right you are. I invented the command. :hehe: 😉
Nope. Not accurate anymore. I used timewarp to alter the past. I am now the inventor :-D:-D
No! No! No!. Go and revise the basics of chrono-temporal dynamics. You can't change the past, it causes paradoxes that result in the collapse of the entire universe.
What you've done is spawn a new parallel universe with the attributes that you want.
Geee... kids these days....
😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.Expert? Yeah right you are. I invented the command. :hehe: 😉
That you did, Gail, and callously informed me that my beloved sp_GoBackInTime had been deprecated.
I am SO looking forward to your presentation on all this at the next PASS Summit. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
GilaMonster (2/9/2010)
CirquedeSQLeil (2/9/2010)
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.Expert? Yeah right you are. I invented the command. :hehe: 😉
Nope. Not accurate anymore. I used timewarp to alter the past. I am now the inventor :-D:-D
No! No! No!. Go and revise the basics of chrono-temporal dynamics. You can't change the past, it causes paradoxes that result in the collapse of the entire universe.
What you've done is spawn a new parallel universe with the attributes that you want.
Geee... kids these days....
😉
Ah yeah! Parallel universes, paradoxes and realities! :w00t:
Awesome when you can use DBCC timewarp to regenerate one's youth. It's nice to be called a kid again 😉
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 -
GilaMonster (2/9/2010)
CirquedeSQLeil (2/9/2010)
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.Expert? Yeah right you are. I invented the command. :hehe: 😉
Nope. Not accurate anymore. I used timewarp to alter the past. I am now the inventor :-D:-D
No! No! No!. Go and revise the basics of chrono-temporal dynamics. You can't change the past, it causes paradoxes that result in the collapse of the entire universe.
What you've done is spawn a new parallel universe with the attributes that you want.
Geee... kids these days....
😉
Of course, by "spawn", you mean accessed. Sometimes it's hard to intuitively follow the difference when taking advantage of alternative universes or re-directed views of our own. We cannot create a parallel existence; only take advantage of its presented state to gain insights or make corrections to our own. If, as has been suggested, you overflow the string count register, for example, you don't really create irrepressively self-replicating objects. For example, the water-toting brooms in "Fantasia" could be taken as a glimpse of multiple chrono-synchronic slices of this same universe or, according to the more widely held hypotheses, spatially synchronic slices of parrallel universes. In either case, Mickey as the sorcerer's apprentice, did not create them; he merely tied the strings together.
So, to give each of you her/his due, you, Gail, invented the command in this (my personal present) universe, and it is perfectly reasonable to accept Jason's claim to have invented it in another. But, as you point out, he did not alter the past to do so.
Meanwhile, I'll do a bit more testing, but I think I've found a set of universes in which TSQL cursors and while-loops are nearly always demonstrably faster than set-based logic.
-
john.arnott (2/9/2010)
I think I've found a set of universes in which TSQL cursors and while-loops are nearly always demonstrably faster than set-based logic.Is Jeff in that universe writing articles to recommend the use of cursors? Is RBAR a "Modenism" for "Row By Agile Row"? 😀
-- Gianluca Sartori
-
Is any of you willing to help this OP with the correct syntax to get his DB back? I don't remember all the parameters right now...
-- Gianluca Sartori
-
Gianluca Sartori (2/10/2010)
Is any of you willing to help this OP with the correct syntax to get his DB back? I don't remember all the parameters right now...I think Gail should, she's the **%$!!* inventor after all.
I'm just an expert is all.
🙂
---------------------------------------------------------------------
-
Meanwhile, I'll do a bit more testing, but I think I've found a set of universes in which TSQL cursors and while-loops are nearly always demonstrably faster than set-based logic.
ooh,ooh, which universe?
I could use dbcc timewarp to move all my databases there and solve all my performance problems in one go!
---------------------------------------------------------------------
-
That you did, Gail, and callously informed me that my beloved sp_GoBackInTime had been deprecated.
which when you opened the code actually just called xp_GoBackIntime
I am SO looking forward to your presentation on all this at the next PASS Summit. 😀
whatever Gail presents on dare you to be introduced as ..........
'Gail shaw, Independent Consultant, SQL server MVP and inventor of DBCC Timewarp'
---------------------------------------------------------------------
-
Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?
-
Or even you use the appropriate settings and order to force a mindmeld / one way merge replication. Then we could just transfer knowledge directly to them :alien:
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 -
They might not all have the firmware capabilities though...
---------------------------------------------------------
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."
-
They might if they were a doll.
Viewing 15 posts - 91 through 105 (of 158 total)
You must be logged in to reply to this topic. Login to reply