Posted by SQL Enthusiast
Article by our editor
Most solutions to the problem of concatenating rows into a single string involve some sort of looping, usually using a cursor or while loop, or recursion using a Common Table Expression (CTE). This tip describes an alternative technique which uses an undocumented Microsoft feature to achieve concatenation.
Comments (1) • 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.
More SQL questions »