Hands-On-Lab: SQL Server Data Types – Part 1

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Data Types – Part 1.

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

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.