150 reputation
5
bio website csharptocsharp.com
location Cambridge, MA
age
visits member for 2 years, 7 months
seen Jan 29 at 12:40

formerly a classical guitarist, currently a web developer and metal dude


May
12
awarded  Popular Question
Feb
10
accepted Do operations on indexed views happen in parallel?
Feb
9
asked Do operations on indexed views happen in parallel?
Feb
9
awarded  Scholar
Feb
9
accepted What is the best practice for storing large data when nvarchar(4000) is sufficient 99% of the time?
Feb
7
awarded  Student
Feb
7
comment What is the best practice for storing large data when nvarchar(4000) is sufficient 99% of the time?
Currently all data in DataValue is < 4000, how come it takes so long to change it to nvarchar(max)? (the change is instant when changing from 2000 to 4000)
Feb
7
comment What is the best practice for storing large data when nvarchar(4000) is sufficient 99% of the time?
yes--the impact of changing when 'MAX' wouldn't be useful for most rows.
Feb
7
asked What is the best practice for storing large data when nvarchar(4000) is sufficient 99% of the time?
Jan
30
awarded  Supporter
Jan
30
awarded  Autobiographer