CREATE TABLE dbo.Jason ( id integer PRIMARY KEY, jason nvarchar(max) NOT NULL ); INSERT dbo.Jason (id, jason) VALUES (1, N'');

DECLARE @char nvarchar(max) = N'X'; DECLARE @id integer = 1, @jason nvarchar(max) = REPLICATE(@char, 4 * 1024 * 1024); -- 8MB SET STATISTICS TIME ON; UPDATE dbo.Jason SET jason = @jason WHERE id = @id;