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 »
SQL Server provides a lot of information in the Data Management Views (DMVs). This script shows how to identify indexes which are never actually used, by using DMVs such as dm_db_index_usage_stats and dm_db_index_operational_stats.
Comments (1) • Read full article »
More SQL questions »
© 2010 - 2016. All Rights Reserved. Design by