Browse by Tags

All Tags » indexes » security
  • Unused indexes on a database, its good and bad

    You may be aware that the indexes on a SQL Server database take up space, so in case of unused indexes its obvious that they waste storage. It is easy to find the indexes using SP_HELPINDEX statement against a table, so to identify the unused indexes what is the way out. In the previous versions of SQL Server Index Tuning wizard is only way out, ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on July 27, 2007