Data types are used to defined what type of data a column can store. As like in any other language SQL server also has data types. This lab is divided into four exercises. The first exercise explains about CHAR and VARCHAR datatypes and performance differences between them. The second exercise explains about NVARCHAR, VARCHAR(n) and VARCHAR(MAX) datatypes. The third exercise explains about IN row and OUT row storage when using VARCHAR(MAX). The fourth and final exercise explains about various integer datatypes and SPARSE column.

Subscribe to Download

File Size1.05 MB
Create DateOctober 21, 2016
Last UpdatedOctober 21, 2016