data types – SQL-PLAY

Find and Change (N)VARCHAR(MAX) to (N)VARCHAR(XXX)

Posted on July 23, 2026July 23, 2026 by Calin OPREA

I know, I know, everything I do is rushed and not properly explained, apologies for that. Anyway.During some investigation, I came across some badly designed tables where most of the columns meant to hold character data were NVARCHAR(MAX), all this while the maximum length of the strings were something in the area of 30-50 characters. … Continue reading Find and Change (N)VARCHAR(MAX) to (N)VARCHAR(XXX) →

much ado about data types

Posted on October 14, 2009 by Calin OPREA

I recently (yesterday, in fact), got to see some amazing recommendations regarding the use of data types. Now I have the chance to provide my personal opinions (guidelines):primary keys: monotonous, ever increasing values - personal choice, but it can introduce unnecessary complexity. So, for the case of small tables, use whatever fits you:as an example, … Continue reading much ado about data types →