A char datatype takes 1 byte per character. It is a fixed length character datatype i.e even though character entered are less than n,fixed memory size i.e n bytes are allocated to those characters.

An installable assembly for SQL Server that adds Deflate (the algorithm used by GZip) Compression functions for nvarchar values. Download the latest release from the Download page. Please note that ...

CREATE ASSEMBLY [bacosoft_lex_sqlserver] AUTHORIZATION [dbo] FROM 'c:\algunaCarpeta\bacosoft_lex_sqlserver.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS; GO CREATE ...

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have blogged about ...