March 23, 2012 at 12:56 pm
GilaMonster (3/23/2012)
Can I have some too?50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...
And if finally went full circle with the OP finding and posting an explanation that he found somewhere that matched what I'd said in first reply and several more times throughout.
Watched that one, too. I thought you were going to go postal a couple of times but you stayed fairly calm.
March 23, 2012 at 1:02 pm
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.
You say that like it should be obvious it's a bad idea. I got so much flak from a client who screamed at me, my boss and anyone else around because a system I wrote couldn't automatically match the drivers imported to the appropriate record in the HR system.
The only thing in the data file on the drivers was name and surname. The HR system had a artificial primary key, a lot of the records were missing ID Number (government-issued ID), so what were they expecting me to use to match, other than magic....
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
March 23, 2012 at 1:02 pm
GilaMonster (3/23/2012)
Can I have some too?50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...
And if finally went full circle with the OP finding and posting an explanation that he found somewhere that matched what I'd said in first reply and several more times throughout.
It is Friday!!! Mousse on the house for all threadizens!!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 23, 2012 at 1:06 pm
Sean Lange (3/23/2012)
GilaMonster (3/23/2012)
Can I have some too?50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...
And if finally went full circle with the OP finding and posting an explanation that he found somewhere that matched what I'd said in first reply and several more times throughout.
It is Friday!!! Mousse on the house for all threadizens!!!
Mousse on the housse?
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
March 23, 2012 at 1:06 pm
Lynn Pettis (3/23/2012)
GilaMonster (3/23/2012)
Can I have some too?50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...
And if finally went full circle with the OP finding and posting an explanation that he found somewhere that matched what I'd said in first reply and several more times throughout.
Watched that one, too. I thought you were going to go postal a couple of times but you stayed fairly calm.
Oh it came very close a couple of times.
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
March 23, 2012 at 1:06 pm
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.You say that like it should be obvious it's a bad idea. I got so much flak from a client who screamed at me, my boss and anyone else around because a system I wrote couldn't automatically match the drivers imported to the appropriate record in the HR system.
The only thing in the data file on the drivers was name and surname. The HR system had a artificial primary key, a lot of the records were missing ID Number (government-issued ID), so what were they expecting me to use to match, other than magic....
What, you mean it isn't? 😉
Luckily, I haven't had to deal with someone like that in a development project. Sort of reminds me a boss I had once though. Basically read my mind and I'll tell you that you are wrong. Hard time know what she wanted me to do at times.
March 23, 2012 at 1:10 pm
OMG..............
March 23, 2012 at 1:13 pm
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.You say that like it should be obvious it's a bad idea. I got so much flak from a client who screamed at me, my boss and anyone else around because a system I wrote couldn't automatically match the drivers imported to the appropriate record in the HR system.
The only thing in the data file on the drivers was name and surname. The HR system had a artificial primary key, a lot of the records were missing ID Number (government-issued ID), so what were they expecting me to use to match, other than magic....
I have run into the same problem. Better yet was the use of the same government id for multiple persons. That was a lot of fun.
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
March 23, 2012 at 1:14 pm
Lynn Pettis (3/23/2012)
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.You say that like it should be obvious it's a bad idea. I got so much flak from a client who screamed at me, my boss and anyone else around because a system I wrote couldn't automatically match the drivers imported to the appropriate record in the HR system.
The only thing in the data file on the drivers was name and surname. The HR system had a artificial primary key, a lot of the records were missing ID Number (government-issued ID), so what were they expecting me to use to match, other than magic....
What, you mean it isn't? 😉
Luckily, I haven't had to deal with someone like that in a development project. Sort of reminds me a boss I had once though. Basically read my mind and I'll tell you that you are wrong. Hard time know what she wanted me to do at times.
Reminds me indirectly of one of my three bosses at a job a couple of years ago. He ended up compulsively disagreeing with me. A couple of times, just to test it, I would wait for him to assert something, then I'd wait a minute or two later in the conversation, and would then repeat back his assertion word-for-word. He would immediately disagree with it. Was amusing in its own way.
I wasn't the only one who noticed that he'd disagree with me about everything. So a co-worker got into the habit of taking anything useful I'd said, which that boss had disagreed with, and parroting it back. The boss would immediately agree and we'd go ahead with whatever plan I had already been told not to do.
And, yes, I'm willing to be that kind of manipulative if it's needed.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 1:14 pm
GilaMonster (3/23/2012)
Sean Lange (3/23/2012)
GilaMonster (3/23/2012)
Can I have some too?50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...
And if finally went full circle with the OP finding and posting an explanation that he found somewhere that matched what I'd said in first reply and several more times throughout.
It is Friday!!! Mousse on the house for all threadizens!!!
Mousse on the housse?
Will that mousse on the housse be lousse?
Tom
March 23, 2012 at 1:14 pm
Okay, I'm getting really punchy.
March 23, 2012 at 1:19 pm
By the by, speaking of Boogle and Ging, Bing's daily picture today is pretty cool.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 1:21 pm
GSquared (3/23/2012)
By the by, speaking of Boogle and Ging, Bing's daily picture today is pretty cool.
Pretty awesome. Wouldn't want to get caught out in it though!
March 23, 2012 at 2:01 pm
SQLRNNR (3/23/2012)
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.You say that like it should be obvious it's a bad idea. I got so much flak from a client who screamed at me, my boss and anyone else around because a system I wrote couldn't automatically match the drivers imported to the appropriate record in the HR system.
The only thing in the data file on the drivers was name and surname. The HR system had a artificial primary key, a lot of the records were missing ID Number (government-issued ID), so what were they expecting me to use to match, other than magic....
I have run into the same problem. Better yet was the use of the same government id for multiple persons. That was a lot of fun.
Seen that too, along with invalid IDs (South African ID numbers have a strict structure). In a government database just to make matters more fun.
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
Viewing 15 posts - 34,921 through 34,935 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply