VARCHAR and NVARCHAR Data Types in SQL Server

Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid values. Developers and DBAs need to know and understand the appropriate data type for each column for better query performance.

This article will deal with the popular data types VARCHAR() and NVARCHAR(), their comparison, and performance reviews in SQL Server.

CodingSight - VARCHAR and NVARCHAR Data Types in SQL Server
Read More

The Best SQL VARCHAR Do’s and Don’ts for Faster Databases

This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with strings.

Also, this is “for your eyes only” because without strings, there will be no blog posts, web pages, game instructions, bookmarked recipes, and a lot more for our eyes to read and enjoy. We deal with a gazillion strings every day. So, as developers, you and I are responsible for making this sort of data efficient to store and access.

With this in mind, we will cover what matters best for storage and performance. Enter the do’s and don’ts for this data type.

CodingSight - The Best SQL VARCHAR Do's and Don'ts for Faster Databases
Read More