Browse by Tags

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

Unused indexes on a database, its good and bad

Published 27 July 7 8:51 AM | SSQA.net

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...

Filed under: sql server, performance, indexes, security, query, unused indexes