October 28, 2003 at 4:38 pm
I have a table someone did a long time ago. Row size is 8080 - 1 single varchar column of 8000 and 12 additional fields. I wonder how the table is still functioning...
What will be the painless solution if I want to turncate this field without losing any data.
Thanks a lot
October 28, 2003 at 4:53 pm
Thats the way its defined? Or actually has that much data? Converting to text col probably your best bet. Might find this interesting:
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp
Andy
October 29, 2003 at 12:23 am
The table is still functioning because the row-data-length did not yet reach the maximum limit for a page.
However, sqlserver did raise a warning regarding this issue at creation time of the table.
If you think the varchar(8000) column is oversized (who wouldn't), you could downsize it after checking its max(datalength(varcharcolumnname)). Keep in mind that the applications probably accept the 8000 bytes for that column. You might want to have that changed too.
Also check the hyperlink Andy supplied.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2003 at 2:09 pm
Thanks a lot. The article make a lot of sence...
If I change the varchar filed to text,what will be the overhead upon the performance and do I need to make some application changes? What is recommended for better performance - to use "'text in row', 'on'" or
to store it out with pointers?
What I'm trying to accompish is to store customer service notes, which has to be retrived as fast as possible - did somebody has experince with that?
Thanks a lot again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply