Tag Archives: sql server

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 )

SQL Server: Find first column with specified value

Returns first column of any table which contains a search value

Comments ( 0 )