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 |
|
hitman
Starting Member
23 Posts |
 Posted - 2008-01-22 : 04:03:50
|
| Hi,I'm going to create a table with 5 columns (and id) to store some texts.This table will be populated with about 50 million rows. What I need to consider is whether use nvarchar(3000) or nvarchar(max) for all columns. Size of 3000 should be enough.What would be better for db performance?There will not be any indexes, except primary key.Thanks-----------------------http://www.sqltips.info----------------------- |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-22 : 04:27:52
|
Why 5 columns?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
hitman
Starting Member
23 Posts |
Posted - 2008-01-22 : 04:35:28
|
| well, each of them is regarding different area and some of them can be empty.-----------------------http://www.sqltips.info----------------------- |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-22 : 04:45:07
|
| worth reading:-http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx?mfr=true |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
hitman
Starting Member
23 Posts |
Posted - 2008-01-22 : 04:52:58
|
| Thanks guys. I'll take a look at it.-----------------------http://www.sqltips.info----------------------- |
|
|
|
|
|
|
nvarchar(max) and max row size