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 (2) • 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 »