September 29, 2011 at 4:55 pm
Hi, lately I've been getting conflicting answers to this.
I read somewhere that VARCHAR(MAX) will always automatically get stored off page. But I can't find that article right now, instead now I keep reading everywhere that it will only get stored off page if there is enough data in it to make the size of the row exceed the allowed 8k.
September 29, 2011 at 5:00 pm
Technet article here: http://technet.microsoft.com/en-us/library/ms189087.aspx
Depends on your settings, either can be true.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply