Thank u Gail. Then what about varchar(4000)? wouldn't it be a better design to use varchar(n) instead of of nvarchar(n) as it'll need half of the pages loaded into...

Thank you Gail. No .. I mean I am a DBA and there seems to be ambiguity about the role of a DBA in many organizations as to what a...

So , that boils down to normalization. Then would it be ok to indiscriminately use nvarchar for every non-numeric/date column with longer lengths without consideration for the usage and occupancy...

Thank you. I'm sorry I'm not currently on this product but worked for few months to help in PT.. so I'm not in a position to provide the DDL ..that's...

Thanks Eirikur and ZZartin .. It's a 600 GB database growing rapidly . The biggest used for BI are over 50 million rows with the biggest at 150 million and...