August 1, 2009 at 1:18 pm
Jack Corbett (8/1/2009)
Jeff Moden (8/1/2009)
Allister Reid (8/1/2009)
I thought someone might try to unpick what he was doing to try to help with the bigger picture...I did just exactly that. I'm not sure if it's his design or someone else's, but like someone else said, there's just so much wrong with what he's trying to do. :sick:
Yeah there was/is a lot that could be fixed there, but I just decided to "throw him a bone" with the caveat that it isn't the BEST solution. Sometimes I just don't want to get into it. If he'd have asked what would work better I'd have stayed in there longer.
Well, no-one really told the OP something was fundamentally wrong. And in fact, I don't know either? What's wrong with generating user names like JohnDoe1/2/3/4/5 as a "natural cause of death" key 🙂 Seriously, any suggestions?
August 1, 2009 at 2:01 pm
Jan Van der Eecken (8/1/2009)
Jack Corbett (8/1/2009)
Jeff Moden (8/1/2009)
Allister Reid (8/1/2009)
I thought someone might try to unpick what he was doing to try to help with the bigger picture...I did just exactly that. I'm not sure if it's his design or someone else's, but like someone else said, there's just so much wrong with what he's trying to do. :sick:
Yeah there was/is a lot that could be fixed there, but I just decided to "throw him a bone" with the caveat that it isn't the BEST solution. Sometimes I just don't want to get into it. If he'd have asked what would work better I'd have stayed in there longer.
Well, no-one really told the OP something was fundamentally wrong. And in fact, I don't know either? What's wrong with generating user names like JohnDoe1/2/3/4/5 as a "natural cause of death" key 🙂 Seriously, any suggestions?
That was my guess, that he was generating usernames, but then he refers to it as an ID, kinda making me think that he's generating a PK, and then to be just inserting the generated key into a table, with no associated data, he's obviously not telling the whole story. I tried to think of sensible questions to ask, that could highlight some of the problems, but reckoned I'd be outta my depth pretty quick (on how to tackle the pretty obvious design problems)... so posted here... that and also I had to share my mounting incredulity.
August 1, 2009 at 2:47 pm
Was that thread closed to protect the innocent and unwary? I couldn't peek at it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 1, 2009 at 2:59 pm
Nope, just posted my own q's to the OP. Wouldn't have expected SSC would hold a lock on a database row in the forum database while someone is formulating a response :w00t:
August 1, 2009 at 6:56 pm
Man! I've had about all I can take of this guy.
Grrrr... :angry:
[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]
August 1, 2009 at 8:02 pm
RBarryYoung (8/1/2009)
Man! I've had about all I can take of this guy.Grrrr... :angry:
Just walk away.
Walk away.
Stop! Don't turn back. Just keep walking away.
😎
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]
August 2, 2009 at 12:57 am
Jack Corbett (8/1/2009)
Although I'm not quite as well-versed in dealing with corruption issues as you are I'll make sure I check in there at least once a day for stuff like:Just run CHECKDB REPAIR_ALLOW_DATA_LOSS
Delete the log file and re-attach the database
Those even I recognize as bad/stupid advice.
Thanks.
If something urgent comes up that's out of your depth, you can mail/PM/tweet Paul Randal. He should be back from vacation.
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
August 2, 2009 at 6:24 am
Oh Jeff, ... You might want to take this one ... 😀
[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]
August 2, 2009 at 6:27 am
Alvin Ramard (8/1/2009)
RBarryYoung (8/1/2009)
Man! I've had about all I can take of this guy.Grrrr... :angry:
Just walk away.
Walk away.
Stop! Don't turn back. Just keep walking away.
😎
You are so right, Alvin. But it was 4AM and he was in my face, and I really thought that I could help .... Grrr ...
[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]
August 2, 2009 at 10:19 am
For all the trials and tribulations there is occassionally a few that express appreciation for what help has been given, for example:
http://www.sqlservercentral.com/Forums/Topic763622-149-1.aspx.
Not to forget those who feed back knowledge to all who visit SSC
http://www.sqlservercentral.com/Forums/Topic763265-392-1.aspx
Renews ones faith in humanity.
August 2, 2009 at 10:41 am
bitbucket (8/2/2009)
For all the trials and tribulations there is occassionally a few that express appreciation for what help has been given, for example:http://www.sqlservercentral.com/Forums/Topic763622-149-1.aspx.
Not to forget those who feed back knowledge to all who visit SSC
http://www.sqlservercentral.com/Forums/Topic763265-392-1.aspx
Renews ones faith in humanity.
Yep. Good point, bit. (I can call you "bit", right? :-))
[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]
August 2, 2009 at 12:17 pm
August 2, 2009 at 3:04 pm
RBarryYoung (8/2/2009)
Oh Jeff, ... You might want to take this one ... 😀
For some reason, that thread hasn't been notifying me of new posts via email. I've responded to that particular post and many of the others. You may find some of my answers to be a bit different than what you might have expected. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2009 at 3:38 pm
RBarryYoung (8/2/2009)
Oh Jeff, ... You might want to take this one ... 😀
By the way, Barry... thank you for the very high compliment about SSC and the Tally table. Coming from someone like you, all I can say is "Thank You" and "I'm humbled".
Shifting gears, I've found the perfect stored proc to convert from RBAR to Set Based for the 3rd part of your wonderful series of articles on "There must be 15 ways to lose your cursors". I just tried to use the damned thing at work and it was taking FOREVER (I had 3.3 million rows in the history table of an unmaintained legacy system and it turns out that EVERY replication run becomes a part of the backup history).
MSDB.dbo.sp_delete_backuphistory
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2009 at 7:37 pm
GilaMonster (8/2/2009)
Jack Corbett (8/1/2009)
Although I'm not quite as well-versed in dealing with corruption issues as you are I'll make sure I check in there at least once a day for stuff like:Just run CHECKDB REPAIR_ALLOW_DATA_LOSS
Delete the log file and re-attach the database
Those even I recognize as bad/stupid advice.
Thanks.
If something urgent comes up that's out of your depth, you can mail/PM/tweet Paul Randal. He should be back from vacation.
Yeah, for any heavy lifting lifting I'll definitely tweet Paul.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 7,111 through 7,125 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply