Performance

In a table with 400.000 rows there is a ntext field that contains html
code of about 15/20 k for each row.
Do you think that if I set <field> = '' should I increase performance
for new insert or I have to delete rows?
Any help appreciated.
Regards.
Fabri
(Lattepi chi pu darti di pi?)Hi
No, leave it as NULL until you use it. With NULL, there is no pointer
allocated for the NTEXT data. As soon as you supply some value, the pointer
needs to be allocated against a page.
Regards
Mike
"Fabri" wrote:

> In a table with 400.000 rows there is a ntext field that contains html
> code of about 15/20 k for each row.
> Do you think that if I set <field> = '' should I increase performance
> for new insert or I have to delete rows?
> Any help appreciated.
> Regards.
> --
> Fabri
> (Lattepiù chi può darti di più?)
>|||Mike Epprecht (SQL MVP) wrote:
> Hi
> No, leave it as NULL until you use it. With NULL, there is no pointer
> allocated for the NTEXT data. As soon as you supply some value, the pointe
r
> needs to be allocated against a page.
Thx Mike, how can I "give" the space to the OS?
I tried so:
dbcc shrinkdatabase ('<db>', truncateonly)
but it seems to not give space to os...
dbcc shrinkdatabase ('<db>') results in very-very-long transaction and I
should avoid this solution...
Regards.
Fabri
(Lattepiù chi può darti di più?)|||Hi
If your data is not on different days then you could default the date when
you store it and then you would not need to use convert, otherwise you may
want to think about storing the time separately.
John
"vanitha" wrote:

> hi,
> my query
> Select A.COL1,B.COL1 from
> A,B
> where convert(varchar(8),A.COL3,108)= convert(varchar(8),B.COL3,108)
> provided COL3 is part of the key in both the tables.
> So if we try to convert the index of the table to time alone the performan
ce
> of the query is affected and it's taking a longer time to execute...
> how to solve this?
> thanks
> vanitha
>