Posted by SQL Enthusiast
Article by our editor
In many circumstances columns in a table can be removed, added or renamed without having to drop and recreate the table. This tip describes how to do this using SQL commands such as ALTER TABLE and sp_rename.
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 »