SQL Server Data Types – Part 1

Description

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.

Exercise 1: CHAR vs VARCHAR datatypes
Exercise 2: NVARCHAR, VARCHAR(n)
and VARCHAR(MAX)
Exercise 3: VARCHAR(MAX), IN Row vs OUT Row storage
Exercise 4: Integer datatypes and Sparse column