2024-03-13
436 reads
Data Types
2023-11-08
443 reads
How to get length of Text, NText and Image columns in SQL Server
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
668 reads
2021-01-12
438 reads
2021-01-05
526 reads
2019-12-19
255 reads
2019-06-11
846 reads
2018-11-27
1,019 reads
Change Integer to BigInt on a Very Large Table
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
5,260 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...