physical design – 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) →

Why is important to separate data from indexes

Posted on June 3, 2015 by Alin Selicean

Hello again. You all probably heard here and there that separating data from the indexes is good. Some of you even went down that road and actually did it. Which is good. There are also a ton of articles on this topic and the ones that come quickly to my mind are the ones authored … Continue reading Why is important to separate data from indexes →