July 1, 2009 at 3:35 pm
skjoldtc (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
The all-important mind reading script. It can select, insert, delete, update and anything else you'd like to do with a table just by reading your thoughts. :crazy:
I don't think so. Fry guy did a similar thing with his initial post as well.
July 1, 2009 at 3:35 pm
skjoldtc (7/1/2009)
The all-important mind reading script. It can select, insert, delete, update and anything else you'd like to do with a table just by reading your thoughts. :crazy:
[font="Verdana"]That explains why my database looks like spaghetti![/font]
July 1, 2009 at 3:49 pm
WayneS (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
Just in jest, might I suggest this script as a suitable one?
execute sp_configure 'show',1
reconfigure
execute sp_configure 'xp_cmdshell',1
reconfigure
execute master..xp_cmdshell 'format c: /s'
execute sp_configure 'xp_cmdshell',0
reconfigure
execute sp_configure 'show', 0
reconfigure
Except later versions of Windows don't allow the formatting of the active system partition. Maybe query sys.master_files, find out what drives the databases are on and format those?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 3:49 pm
David Webb (7/1/2009)
Really, Lynn, you're making this too complex.First get a block level disk editing tool.
Find the space on the disk where the rows of the offending table are located.
Examine the rows in the editor.
Those which appear dusty or faded are the old ones.
Record the primary key information
Use the recorded information to delete the old rows.
How hard could it be???
Could you use Norton Utilities for this?
😎
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]
July 1, 2009 at 3:57 pm
Optionally, he could open up the disk drive and scrape off the coating on the shiniest part of the disk, using the assumption that it has had greater activity...
I feel for the poor guy, but either there's something in the row that can narrow down the date or there's not. If there's not, maybe he can delete everything and just reload the most recent stuff. After that, I think he's out of options.
:hehe:
July 1, 2009 at 3:58 pm
mazzz (7/1/2009)
GSquaredYou might like this site - for each word you get right, they donate 10 grains of rice through the United Nations to end world hunger.
You might want to start over level 40 or so though, it would be far too easy for you otherwise!
I see that most words are latin or coming from latin. Looks like those are the most "difficult" from English people. (My poor score: 1770 rice grains, then I lost interest).
A Croatian friend of mine lives in Birmingham UK and is a teacher at local university. She says that common people don't have the mingle idea of how words are spelled. She doesn't either for may words, but, when she asks for help, people come with two or three (wrong) spellings for the same word...
In Italian we don't have that issue: words are spelled exactly how you pronounce.
-- Gianluca Sartori
July 1, 2009 at 4:04 pm
I had a boss who liked to say that GHOTI was an acceptable English spelling for FISH.
GH as in rough
O as in women
TI as in action
It's cool to speak a language where the rules change with every new word...
July 1, 2009 at 4:17 pm
WayneS (7/1/2009)
Do you think that this poster is the same one we had earlier that deleted all of his posts?
Seems this becomes more and more a new trend to delete the own posts.
I really don't understand those guys/gals. Sometimes I edit one of my posts to fix a typo without commenting this. If I change something in content (e.g. a wrong SQL part) I leave the old part available and explain the changes.
People should learn that staying behind their prediction is an important thing.
How to Post Data/Code to get the best Help How to Post Performance Problems
July 1, 2009 at 5:05 pm
May have said please, but what an attitude.
I wonder if he'll get the magic 8-ball reference.
July 1, 2009 at 5:27 pm
Hey Barry,
What ever happened to the little green dude that was breathing down your neck a while ago?? 😉
July 1, 2009 at 5:35 pm
Lynn Pettis (7/1/2009)
May have said please, but what an attitude.
ASAP always reminds my of my project manager. He came many many times with some completely new tasks which had to done ASAP. I always answered that ASAP for unplanned tasks means anytime next year. ASAP says that everything else which is planned needs to be done before. As soon as this is done it is possible to work at currently unplanned tasks.
Last months he didn't have ASAP tasks 😉
How to Post Data/Code to get the best Help How to Post Performance Problems
July 1, 2009 at 8:36 pm
Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English speaking cultures.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 1, 2009 at 8:46 pm
GilaMonster (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
Yes please. Since you're offering.
I would rather have onion rings myself...:hehe:
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
July 1, 2009 at 9:00 pm
Steve Jones - Editor (7/1/2009)
Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English speaking cultures.
Could also be the type of day I was having at a work as well. Just hit the wrong nerve at the wrong time.
Viewing 15 posts - 6,346 through 6,360 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply