Posted by SQL Enthusiast
Article by our editor
The length of a varchar column can be determined using the len() function, however this generates an error when used with the text datatype. Fortunately we can use the datalength() function to work out the length of a text field. This article shows how.
Comments • Read full article »
It's useful to periodically check if there are any old database files that can be deleted from a SQL Server. Usually database files will be deleted along with the database, however this is not always the case. This script will identify unused files.
Comments (1) • Read full article »
More SQL questions »