Top
Search The Blog
About this site

@RoyOsherove

Subscribe!

This site aims to connect all the dots of my online activities - from tools, books blogs and twitter accounts, to upcoming conferences, engagements and user group talks.

from 5whys.com
My "Projects"
Twitter: @RoyOsherove
Search
My Book: The Art of Unit Testing
Latest Posts
Video Navigation
Forms
« VS.Net multi language bug - 2.5 years and still going strong? | Main | We Are Morons: a quick look at the Win2k source »
Tuesday
Feb172004

SQL relations considered harmful?

DateTuesday, February 17, 2004 at 10:31PM
OK. So I'm no SQL server guru but I do consider myself to know *something* about it. Which is why it was really weird to read this post and realize that I have no idea what that guy was talking about. Domains? Not using a relation in favor of exporting domain views? using CHECK constraints instead of relations? I know CHECK constraints but funnily enough I was never in a position to actually use them for these kinds of things. Guess that comes with not knowing the territory..
 
How widespread are these methods? when should I use them? are there any specific guidelines that talk about this issue in particular somewhere where I can get more enlightenment?
AuthorRoy Osherove | CommentPost a Comment |
in

PrintView Printer Friendly Version

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
Alert
Comment Moderation Enabled
Your comment will not appear until it has been cleared by a website editor.

Notify me of follow-up comments via email.