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
579 reads
2021-01-12
433 reads
2021-01-05
518 reads
2019-12-19
244 reads
2019-06-11
843 reads
2018-11-27
1,011 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
3,957 reads
2017-10-05
1,056 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 Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Looking for a HA solution for SQL server for our branch offices. Current setup...
Comments posted to this topic are about the item The July Fourth Anniversary
Comments posted to this topic are about the item Independence Day 2022
Ask SSC