At 11:09 AM 9/17/2003 -0500, Steve Fogelson wrote:
A while back I had asked about Text vs. Note fields.
A few responses indicated that they keep all "note"s in a separate table. Evidently problems with broken pointers.
I assume you design your DBs with a table for ALL notes. And all the other tables contain Note_ID fields where appropriate, that point to that note in the note table. Then use a view to read a row including the note.
Are these assumptions correct?
Could someone elaborate on this design and problems with broken pointers. How is this design strategy easier to fix broken pointers?
Steve,
Take a look at the following two articles:
From The Edge: http://www.razzak.com/fte
Understanding and Using VARCHAR Data Type (07/18/2002)
Finding and Fixing Broken Indexes (04/30/2002)
Hope that helps!
Very Best R:egards,
Razzak.
