I have a rather large historical table that is now slowing down my users. One of the big things I did that will alleviate the issue is converting the text fields to nvarchar(max) or varchar(max) fields. I am going with nvarchar because of Unicode/conversion issues that may arise.

My question is, will the front end, if declaring an explicit TEXT value, be implicitly converted when inserting into the table?

I am wondering as the fields are implicitly converted using an ALTER TABLE statement that I used for the initial conversion.

This table is used in rather a great many places and putting a CONVERT everywhere that its referenced will be problematical to say the least.

I tried testing this locally but local TEXT variables are not allowed when running locally.