Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Linok
Starting Member
34 Posts |
 Posted - 2008-05-13 : 15:14:26
|
| Hey everyone,I'm working on a document management system that will allow the users to tag docs. Would it better in terms of performance and general maintenance to have all the tags comma de-limited in a column of the doc record, or have each tag in a row of an associated table?Thanks in advance! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-13 : 15:16:12
|
Second choice.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-13 : 15:16:22
|
| You should normalize your database, so it is better to not comma separate them into one column.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
Linok
Starting Member
34 Posts |
Posted - 2008-05-13 : 15:21:41
|
| That's what I was thinking (and have implemented), but last week we had a company demo an unrelated product that kept all the tags as a comma-delimited column in the row, and I wasn't sure if they knew something I didn't. :-PThanks for the quick response! |
|
|
|
|
|
|
What's a best way of tagging items?