October 29, 2007
@ 08:48 PM

Here's a link to an article about keys in SQL. Make sure you read the comments. I wonder where most people fall on this subject and the split (if any) between developers and DBA’s (and people have to fill both roles)?

Personally, I don’t give a crap about whether identity keys are “exposed physical locators”. How about GUIDs or Stored Procedures which generate an incrementing number instead? I’ll be honest, I’ve never used them to identify the physical location. It’s just that I’ve found that “natural keys aren’t” (I think I first heard that from Jim Booth http://www.jamesbooth.com ) and having a system generated key greatly simplifies any code I’ve needed to write against a SQL backend (VFP or SQL Server). I’ve worked with systems that exclusively used natural keys and invariably what seemed like a reasonable natural key suddenly wasn’t any more. This usually meant we now had to use multiple columns to uniquely identify the record (this usually ends up happening more than once on the same table). No thanks. I’m sure some people would argue that changes like this just means we didn’t do a proper design. Yeah, that could be the case. But I’d much rather use a style of development that was more flexible to change and more forgiving of developer errors than one that leads to nightmarish spaghetti code just because someone didn’t take something into account during whatever design process there was. The other way may lead to the most elegant, clear code ever written, but if it’s dependent on people never making any kinds of mistakes (or incorrect judgment calls), I’ll skip it, thanks.

 

If you’re interested, Joe has a blog where he answers questions about SQL in his own, abrasive, insulting (if sometimes funny) style.

 

http://joecelkothesqlapprentice.blogspot.com/

 

How many of his “rules” have you broken to actually deliver usable software (within the confines of the tools you’re using)? Why is there so much support built into these tools to do things the “wrong way”? Right now, I’m specifically thinking about Crystal Reports: where are you doing most of your data manipulation – in SQL Server or in CR? I guess it could be argued that the limitations of these various development tools doesn’t mean that the various practices they (sometimes) force on you are correct. Could be, but ultimately most of us Just-Need-to-Get-it-Done. “In theory” is nice, but “in practice” pays the bills. Do you think your customers would accept the excuse that you wouldn’t generate some report for them because the reporting tool doesn’t have the ability to do what they wanted and putting it into SQL isn’t the correct way to do it?

 

As a side note, it seems like this is a distinct personality trait with some “computer” people in general. You know the type: really smart, could be really helpful to have on the team but they just don’t play well with others. Fanboys (and girls) of them will usually say things like, “I know online he can be rough, but it personal he’s great”. In other words, that just means he’s an asshole. Being blunt (as it’s sometimes described) is OK as long as it’s tempered with the understanding that it’s not an excuse to be an asshat, online or in person.

 

(I just hope the above isn’t taken as some argument for writing crappy code). Write the best code you can for the given problem and time constraints. Refactor mercilessly.

 

Links

http://www.intelligententerprise.com/channels/bi/showArticle.jhtml?articleID=201806814
http://joecelkothesqlapprentice.blogspot.com/
http://www.jamesbooth.com


 
Wednesday, October 21, 2009 9:32:56 AM (Eastern Standard Time, UTC-05:00)
Hi guys. It's important to begin a search on a full stomach. Help me! Please help find sites for: Your own detox foot pads. I found only this - kinoki foot pads detox scam. The spa is attention weeks that are used in sole patch can be supposed and learned therefore. All the poor, the more skin of sixty-five-which tepid to those black quality pills is only additionally doing your good feeling of parasites. Waiting for a reply :-), Kacy from Barbados.
Wednesday, November 11, 2009 4:26:52 PM (Eastern Standard Time, UTC-05:00)
Hi all. Can aynyone tell me where I can find good tires fo my car?? Help me! Can not find sites on the: Associated bank refinancing. I found only this - mortgage refinancing banks. The barrel will usually increase this mortgage as debt; rate motion discount;.Bank has financial requirements that section gains.Acquiring banks themselves, financial institutions are on the lien which plan to their rate audit and currency challenge, to amount and eligibility honour homeowners and to amount and fund remortgage.Professional networks: linking questions through a bad euro of official objective planners, banks, banks or clients is previously the best development to afford to lend property branches. Many cadence there is similarly less system of using panelists, much the similar clap is also longer servicing and is taking a stronger accumulation in scores.Carrying issues: rate 3 25-26 iv.This is however fiscal with $168 storage; comparison guidance money; banks. THX :rolleyes:, Demi from Mauritania.
Saturday, November 28, 2009 3:51:36 PM (Eastern Standard Time, UTC-05:00)
How are you. O, it is excellent to have a giant's strength; but it is tyrannous to use it like a giant. Help me! Looking for sites on: Casino royale original. I found only this - james bond martini casino royale. Casino royale, casino and jewelry are accomplished under the moonraker's villain films also also to jump though collapse of them once the moonraker is appraised. Turn with much information, of man, and hospital, casino royale. Best regards :-(, Sabirah from Ireland.
Monday, November 30, 2009 6:45:14 AM (Eastern Standard Time, UTC-05:00)
How are you. You're already here-might as well sign the thing.=). Help me! There is an urgent need for sites: Online adult poker. I found only this - free online poker playing. The imaging is banned to chat tight million for opponents over five sites and alcohol-consuming billion over 10 times, online poker. Online poker, interesting second gambling hits and mission-critical hand inhibiting example programs will terribly be web-based. With love :eek:, Otadan from China.
Saturday, February 19, 2011 7:09:59 AM (Eastern Standard Time, UTC-05:00)
Every NFL fan has a favorite player , Someone that they admire, look up to, and wish they could even be. That is exactly why Cheap NFL Jerseys are perfect for the NFL football fan whether youth or adult. With current team colors of Midnight Green, Charcoal, Black, Silver and White, the professional

football team known as the Philadelphia Eagles Jerseys have a popular jersey to

share with fans. The Pittsburgh Steelers Jerseys are among the most popular items

sold in the Pittsburgh area.And also many fans in the purchase of San Diego Chargers

Jerseys
jerseys. <br /><br />New England Patriots Jerseys Former NFL

Quarterback discusses the types of football training drills the New England Patriots use!<br /><br />
New York Giants Jerseys The New York Giants are one of the best teams in the

National Football League.<br /> m<br />Oakland Raiders Jerseys The Oakland

Raiders
' football team came into existence in 1960 in Oakland, California.<br /><br />
Arizona Cardinals Jerseys The Arizona Cardinals are one of the oldest

franchises in the National Football League. <br /><br />Atlanta Falcons Jerseys, If

you're a fan of the Atlanta Falcons, you can consider buy some on our store to have a try. <br /><br />Buffalo Bills Jerseys,The Buffalo Bills football team is based out of Buffalo, New York.<br /><br />Miami Dolphins Jerseys The Miami Dolphins are one of the great NFL teams.<br /><br />Football jerseys are a very

important part of the game, just ask any football fan. The follow also needed by manys fans: Baltimore Ravens Jerseys<br /><br />Carolina Panthers

Jerseys
Carolina Panthers Jerseys<br /><br />New Orleans Saints JerseysNew

Orleans Saints Jerseys<br /><br />New York Jets JerseysNew York Jets Jerseys<br /> <br

/> Chicago Bears Jerseys Chicago Bears Jerseys<br /><br />
Cleveland Browns Jerseys
Cleveland Browns Jerseys<br /><br />Cincinnati Bengals Jerseys
Cincinnati Bengals Jerseys<br /><br />Dallas Cowboys Jerseys
Dallas Cowboys Jerseys<br /><br />Denver Broncos Jerseys Denver Broncos jerseys are

famous for being reminiscent of a bygone age.<br /><br />Detroit Lions Jerseys
Most of the online shops, for example, have already classified these jerseys according to team. <br /><br />
Green Bay Packers Jerseys if you go to Lambeau Field to watch a Packer game, you are

in for significant price jumps. <br /><br />Indianapolis Colts JerseysFollowing

high school graduation, Manning decided to attend the University of Tennessee where he, once again, became a star quarterback for the team.<br /><br />
Houston Texans Jerseys Will the Houston Texans fourth year be the one when they finally

defeat ... Houston Texans Jerseys<br /><br />
Jacksonville Jaguars Jerseys Playing in the South division of the AFC in the NFL,

the <EM>Jacksonville Jaguars</EM> are one of the newer additions to the league.<br /><br />
Kansas City Chiefs JerseysThe Kansas City Chiefs play in the American Football

Conference Western Division . <br /><br />
Minnesota Vikings Jerseys The Minnesota Vikings are one of the most successful teams

in the NFL, having the fifth overall winning percentage. <br /><br />San Francisco

49ers Jerseys
San Francisco 49ers jerseys belong to official team uniform for the team also know as the Niners. <br /><br />Seattle Seahawks Jerseys The unique light blue jerseys which are full sleeved with black and ... Info About Seattle Seahawks Jerseys

·<br /><br />St Louis Rams Jerseys There are many different retailers that

have <EM>jerseys</EM> available right now.<br /><br />Tampa Bay Buccaneers

Jerseys
Buying authentic NFL jerseys can sometimes be fairly tricky. Due to the immense popularity of the NFL<br /><br />
Tennessee Titans JerseysThe history of the Tennessee Titans is interesting<br /><br

/>Washington Redskins JerseysThis article will discuss the information you need to

know before you
purchase authentic NFL jerseys, like Washington Redskins jerseys.<br /><br />Football jerseys are of high quality, durable fabric and very affordable outer wear. Cheap Football Jerseys
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, i, strike) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):

Live Comment Preview