I am doing on an online music store and I have 40+ artistes in my database. Each artist has a bio (paragraphs of information about his life). How do I accomodate all the bios in my database? I am using MS SQL Server 2005.
You can use the VARCHAR datatype to store up to 8000 characters (4000 in unicode).
You can use the TEXT datatype to store unlimited string data, but you are then somewhat limited in your ability to query and search this data.
In SQLSVR 2500 you can use the new VARCHAR(MAX) datatype.
If it's not practically useful, then it's practically useless.