Apr 3, 2013. (e.g. varchar(10) to varchar(max)). collation modifications on non-unicode columns that change character set or code page. (See Collation Hell Part 3 by Dan. have to touch any of the actual data. So the size of the table will not impact the time it takes SQL Server to process the ALTER TABLE command. Mar 17, 2014. CREATE TABLE Allthings ( thingName NVARCHAR(300) COLLATE French_CS_AS , thingType NVARCHAR(100) ,…