Comment On Good Table Names

Tim Heuer seems to have some pretty bad luck when it comes to inheriting database systems. Believe it or not, today's screen shot comes from the Tables view in SQL Server Enterprise manager and is not a list of files. Thankfully, the DBA used common-sense, easy to understand column names for these tables, such as [c:0x:x:Line1] for the summary field.  [expand full text]
« PrevPage 1Next »

re: Good Table Names

2004-08-03 14:41 • by M. Eaton
WTF? I'd love to hear the justification for this crap. A PHB must have gotten his hands into this somehow. :-)

re: Good Table Names

2004-08-03 15:22 • by Jonathan M. Hollin
That is so scary!

The table names aren't too bad I guess (apart from the extraneous ".xml", but those columns - Jeez!!!

I hope the documentation is good.

re: Good Table Names

2004-08-03 15:48 • by Andy Johns
Looks like auto-generated crap to me. I've seen worse -- like old mainframe COBOL copybooks being auto-converted into web services. The resulting XML can look like:
<A>
<AB>SCR-VAL</AB>
<Q>1</Q>
<Z2>
<Z1>7</Z1>
<H>GEORGE</H>
</Z2>
</A>

Nice an human-readable xml huh?

re: Good Table Names

2004-08-03 15:51 • by Eric Newton
At least the XML overhead is low ;-)

re: Good Table Names

2004-08-03 21:27 • by TJ
Holy gobldy goop Batman!!!

Thats whay you get when you let business analyst design databases. What a cluster F.

re: Good Table Names

2004-08-04 06:40 • by Mario Goebbels
Wow, just wow! Pray for me that I'll never inherit any bollocks like this!

re: Good Table Names

2004-08-04 11:31 • by Tim Cartwright
Tim H, it soooo STINKS to be you, I feel for you... :-(

re: Good Table Names

2004-08-04 12:54 • by Phooboy
Hmmm - an 8-byte column named "guid" - wonder what the strategy is to ensure global uniqueness?

Just more confusion to heap on this mess...

re: Good Table Names

2004-08-04 14:15 • by cablito
Yeah, I know whats the [c:1:0:h] prefix is for... its for versioning.. so you know that field belongs to the "database" version 1.0 revision 'h'.

I bet it was a pleasure to code SQL joins on that database... lol

re: Good Table Names

2004-08-05 13:35 • by Curt Teunissen
Finally a WTF where no-one said "ya know there is a perfectly acceptable reason for doing this blah blah blah"

re: Good Table Names

2004-08-12 15:48 • by Lev Demidov
Actually the column names look like SQL XML EXPLICIT syntax. Judging from that and the table names, it this database looks like a "creative" way to store xml files. Select a row by id, and based create the xml from the column names.

re: Good Table Names

2004-09-09 21:00 • by Jeff Darcy
I think it's Estonian notation - similar to the better known Hungarian notation, but without the pretense of being intended for any purpose but obfuscation.

Re: Good Table Names

2008-12-18 22:03 • by wholesale jordan shoes (unregistered)
Nike Jordan shoes|Air Jordan Shoes|Jordan Shoes Jordan Shoes Air Jordan Shoes
Wholesale jordan shoes|Jordan Shoes Nike air jordan|Jordan Shoes Air Force One Jordan Shoes
Jordan Shoes jordan wholesale|Jordan Shoes Nike Jordan Shoes|Jordan Shoes Jordan Shoes Air Jordan Shoes
Jordan Shoes Wholesale jordan shoes|Jordan Shoes Wholesael air jordan|Jordan Shoes Air Force One

runescape gold

2011-05-06 01:20 • by runescape gold (unregistered)
« PrevPage 1Next »

Add Comment