There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
2022-04-20
2021-09-29
615 reads
2021-01-12
437 reads
2021-01-05
525 reads
2019-12-19
252 reads
2019-06-11
845 reads
2018-11-27
1,014 reads
This article will show how to change the data type of a column when the table contains more than 1 billion records.
2017-11-09
4,726 reads
2017-10-05
1,057 reads
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
2016-10-03
1,639 reads
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Hello Gurus, I have a requirement and need to implement the solution quickly. SQL...
Comments posted to this topic are about the item Deleting the Standby file
Comments posted to this topic are about the item If You Build It, Will...
Ask SSC