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


Version1.0
Download4
File Size1.05 MB
Create DateOctober 21, 2016
Last UpdatedOctober 21, 2016
SQL Server Data Types Part 2
Delayed Durability in SQL Server 2014