April 11, 2012 at 7:49 am
I had to complain about this somewhere.
I'm creating a visio diagram for the database behind a commercial product. There's a lot wrong with this database, but we've just determined that they use the same name for the column that is the primary key of two different tables. The data in these two columns do not map to one another and they're used as foreign keys all over the database.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 11, 2012 at 8:03 am
rmechaber (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity. The word it wanted me to type in to verify my authenticity? "fraudulently"I should be seeing you there then.
Excellent. Sadly it wont be as fancy as last years, last years was fantastic.
I have heard that rumor
It's no rumor. It's a month away and no schedule is up yet.
ON that note SQLSaturday #146 - Nashua NH is now accepting speakers http://www.sqlsaturday.com/146/callforspeakers.aspx and we'd love to have a bunch of threadizens. The date in October 20.
Thanks for that Jack, I hope to attend. Will you be coming to Newington next week?
Rich
Nope. I'm going to be in Houston all next week. That'll likely be the only meeting I miss.
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
April 11, 2012 at 8:03 am
Stefan Krzywicki (4/11/2012)
I had to complain about this somewhere.I'm creating a visio diagram for the database behind a commercial product. There's a lot wrong with this database, but we've just determined that they use the same name for the column that is the primary key of two different tables. The data in these two columns do not map to one another and they're used as foreign keys all over the database.
I've seen worse.
In one of the applications I have to extract from, every PK column is called "ID", then other tables FK to it with a random name of <tablename>_ID, <tablename> or something entirely unrelated depending on which of their developers designed that particular table. You literally can't write a query without interrogating the metadata to see where FK relationships exist.
Then, to make things worse, I'll assume that a reference to <tablename> in another table links back to the table I want, only to find that it's a denormalised code or name that's randomly added in.
April 11, 2012 at 8:23 am
HowardW (4/11/2012)
Stefan Krzywicki (4/11/2012)
I had to complain about this somewhere.I'm creating a visio diagram for the database behind a commercial product. There's a lot wrong with this database, but we've just determined that they use the same name for the column that is the primary key of two different tables. The data in these two columns do not map to one another and they're used as foreign keys all over the database.
I've seen worse.
In one of the applications I have to extract from, every PK column is called "ID", then other tables FK to it with a random name of <tablename>_ID, <tablename> or something entirely unrelated depending on which of their developers designed that particular table. You literally can't write a query without interrogating the metadata to see where FK relationships exist.
Then, to make things worse, I'll assume that a reference to <tablename> in another table links back to the table I want, only to find that it's a denormalised code or name that's randomly added in.
Is this an internal database or a commercially available product? Horrible either way.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 11, 2012 at 9:02 am
GilaMonster (4/10/2012)
Brandie Tarvin (4/10/2012)
Oddly enough, that captcha came up when I was doing something at one of my writer association sites.On that point, do you have any sites/apps that you can get a writing practice topic or starting scene or similar each day? I had a site a while back, but it disappeared.
I know some people post such things (or used to). I'll look around and see what I can find. In the meantime, does this help? http://brandietarvin.livejournal.com/48600.html
April 11, 2012 at 9:04 am
jcrawf02 (4/11/2012)
GilaMonster (4/10/2012)
Brandie Tarvin (4/10/2012)
Oddly enough, that captcha came up when I was doing something at one of my writer association sites.On that point, do you have any sites/apps that you can get a writing practice topic or starting scene or similar each day? I had a site a while back, but it disappeared.
and I thought that was the Today's Random Word thread...
That's a psychology project. @=)
Actually, though, that is a good place to start too.
April 11, 2012 at 9:58 am
Is it too early to pre-order signed copies?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2012 at 9:59 am
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspx
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
April 11, 2012 at 10:15 am
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspx
Wow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
April 11, 2012 at 10:16 am
The Dixie Flatline (4/11/2012)
Is it too early to pre-order signed copies?
I have lost track of which post you are responding too, but will happily assume you're talking about my work and not someone else's. @=)
April 11, 2012 at 10:17 am
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he is getting defensive, not quite hostile.
April 11, 2012 at 10:22 am
Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he is getting defensive, not quite hostile.
I like the "don't make me do any work, just give me the answers!" attitude. The writing is horrible too, everything about his(her) posts smacks of laziness.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 11, 2012 at 10:23 am
Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he is getting defensive, not quite hostile.
No, hostile. Definitely hostile.
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
April 11, 2012 at 10:28 am
GilaMonster (4/11/2012)
Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he is getting defensive, not quite hostile.
No, hostile. Definitely hostile.
Yea, he has stepped over that line. Didn't take long, did it?
April 11, 2012 at 10:29 am
Stefan Krzywicki (4/11/2012)
Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he is getting defensive, not quite hostile.
I like the "don't make me do any work, just give me the answers!" attitude. The writing is horrible too, everything about his(her) posts smacks of laziness.
Not laziness, entitlement. I am entitled to get the answers I want without having to work for them.
Viewing 15 posts - 35,311 through 35,325 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply