Let me show you why data types still matter

08/05/2024

When building a SQL Server database, the selection of the data types is, sometimes, neglected. Usually, until you get lots of data and/or more concurrency you may not notice any problems. This means that NVARCHAR(MAX) is okay, right?

We also have examples where while doing some math operations or even concatenating columns/variables you won’t get the result you expect! You may think that SQL Server is buggy but actually, it’s just doing its thing, in the way it works.

In this session, we will go through some examples that hopefully will make you think twice next time you are deciding on your data types.

Speakers

Cláudio Silva

Data Platform Architect, T-SQL Performance Tuner, PowerShell Automator

I work as a Data Platform Architect.
I love performance tuning and I’m also a PowerShell lover who automates any process that needs to be done more than a couple of times.

I’m a Microsoft Data Platform MVP and an active SQL Server and PowerShell community member. Also, I’m a contributor to open-source projects such as dbatools (https://dbatools.io) and dbachecks (https://dbachecks.io).

I blog at https://claudioessilva.eu .