Cláudio Silva
claudioessilva.eu
SQL Server DBA and PowerShell lover to automate any process that needs to be done more than a couple of times.
SQLBits 2024
Let me show you why data types still matter
Selecting the right data types is still important. Let's see some examples of why!
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 20 minutes we will go through some examples that hopefully will make you think twice next time you are deciding your data types.
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 20 minutes we will go through some examples that hopefully will make you think twice next time you are deciding your data types.