Viewing 15 posts - 14,056 through 14,070 (of 18,923 total)
Are you expecting to store japanese or foreign languages in that table?
If not you can use varchar on all Fields.
The concat field can be dropped as it is the aplication's...
August 23, 2005 at 8:56 am
17*255*2 = 8670 + 8000 = 16670, so 16845 doesn't seem far off the total size.
Run this for the exact total :
Select SUM(C.Length) as Length from dbo.SysColumns C where...
August 23, 2005 at 8:44 am
nvarchar = 2 bytes per character, so you just the Address_Concat field is worth 8000, which is already very close to the limit.
August 23, 2005 at 8:22 am
If you make an unencrypted version (I mean EXACT COPY/PASTE). Does it work or does it still have the problem?
August 23, 2005 at 8:02 am
Make a new calculated column (with the replaced version). Index it and use it in the join.
August 23, 2005 at 6:53 am
Nice work... too bad I won't ever need that
.
August 22, 2005 at 11:21 pm
"It should give error when execute the select statement."
What statement is that??
August 22, 2005 at 11:19 pm
HTH = Happy to help. (can also mean Hope this helps)
I can't post it untill I'm sure the thread is closed...
August 22, 2005 at 11:17 pm
It's a secret organisation... and I already said too much
.
August 22, 2005 at 11:16 pm
Governement is not meant to be entertaining
.
August 22, 2005 at 11:13 pm
It simply wraps the description with spaces so that you get a hit.
August 22, 2005 at 3:12 pm
Hehe, those 30 hours of C++ are finally paying off
.
August 22, 2005 at 3:05 pm
Viewing 15 posts - 14,056 through 14,070 (of 18,923 total)