Archive › February, 2016

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )