we normally use varbinary(max) to store large amounts of data.

ie:

insert into schema0.table1( Column00_INT, Column01_VBMAX)
select 1 as Column00_INT, replicate('*', 100000000000)

Then when we read back we...