Search Options
close
Search the following clips:
All Clips
Everyone's Clips
My Guides
Sign Up
Install
Learn More
Login
The Golden Rule of Data Manipulation
travislaborde
follow
2
6-12-2008 7:47 AM
316 views
tags:
programming
travislaborde
says:
I always fail at phone number.
Add a Comment
Login
to Comment. Not a member yet?
Sign up
Related Clips
MSNBC's Network Chief Down Plays The Pers...
Free Online Courses from Great Universities
OH voting machines contain critical vote-d...
Cheezburger LOLz for ALLz
Jyte: lightweight reputation engine using ...
Hidden Surprises in .NET 3.5 Service Pack 1
Georgian Villagers Recount Tales Of Marauders
More clips from
travislaborde
Magic Windows Trick: Query and Reset Termi...
New New Old Job Today!
I Start at a New Job Today!
Today's Top Clips
36 views of Mt Fuji
A picture is worth a thousand words
Halliburton Sued for ‘Human Trafficking’
American People are More and More Afraid of Their Government
Why Everyone Should Be in Favor of Reducing Taxes on the Rich
Another Stonehenge Found Deep In Amazon Forest
Natural Fashion
Animal Hair Styles
McCain's VP Choice a Marginal Creationist
High speed waterfigures image & video - magnificent!
visit the
Top Clips page
View the Top Clips from
June 12, 2008
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/778e9308-0900-4333-8c4b-1067039d9c61/20FB0F3B-6C8E-4367-9A1C-56ABC62F481D/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935" href="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935" style="font-size: 11px;">weblogs.sqlteam.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935"><H2> <A href="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx" title="Title of this entry." id="viewpost_ascx_TitleUrl">The Golden Rule of Data Manipulation</A> </H2></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935"><DIV> The "Golden Rule of Data Manipulation" is a simple, but important rule that you should always follow when designing a database, writing database code, or really writing <SPAN>any </SPAN>application code at all for that matter:</DIV></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935"><SPAN>"It is always easier and more flexible to combine data elements rather than to break them apart"</SPAN></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935"><DIV> In other words: Concatenation is easy. Parsing is hard. Often, <SPAN>very</SPAN> hard -- or even impossible depending on the data.</DIV></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://weblogs.sqlteam.com/jeffs/archive/2008/06/11/golden-rule-of-data-manipulation.aspx#38935"><DIV> <SPAN>A Data Model that requires Parsing = A Poor Data Model</SPAN></DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;"> </td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/20FB0F3B-6C8E-4367-9A1C-56ABC62F481D/blog/" title="blog or email this clip"><img src="http://content9.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
Clipmarks
Home
New Clips
Top Clips
Dashboard
Popular Topics
News
Life
Science
Technology
Entertainment
Get Started
Sign Up
Install Clipping Tool
How Clipping Works
Clip-to-Blog™
ClipSearch
Tools and Resources
FAQ
ClipWeek
Top Clippers
Top Tags
Site Map
About Clipmarks
About Us
Contact
Blog
Copyright
Privacy
EULA
OK