2025-09-12
1,666 reads
Data Types
2025-02-14
506 reads
2025-01-31
453 reads
2025-01-15
1,854 reads
GUID in SQL Server
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
2024-12-30
2024-03-13
441 reads
2023-11-08
446 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
711 reads
2021-01-12
441 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
Don't Let Corner Cases Drive Your Design
Comments posted to this topic are about the item Don't Let Corner Cases Drive...
A New Operator
Comments posted to this topic are about the item A New Operator
Troubleshooting Common SQL Server Errors: 823, and 824
Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers