Posted by SQL Enthusiast
Article by our editor
When copying data into a new table using SELECT INTO it can be useful to add an identity column at the same time, especially where the source data does not already have a primary key. This tip describes how to do that.
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 »
© 2010 - 2016. All Rights Reserved. Design by