2024-03-13
384 reads
2024-03-13
384 reads
2023-11-08
433 reads
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
630 reads
2021-01-12
438 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
5,025 reads
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
By Steve Jones
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...
Someone landed a PowerBI mess in my lap, and near as I can tell,...
I want to have a a secondary ready-only database available for reporting, which is...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers