How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower

(Bob Dorr) The scenario: •Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) •Data has both small and large storage for different rows •Issued ALTER TABLE … ADD COLUMN …NVarCharColumn… NVARCHAR(MAX) •Issued update MyTable set NVarCharColumn = <> •Issued AL

Read More - Register for Free Membership