Tag: index
-
Find Indexed column details in a database
I was looking for a script to find out the indexed column details as part of our migration. I tried to use sp_helpindex however it requires a object name which means you can find details for only one table at a time. My requirement is to get details about all indexed columns across the database…
-
SQL Server 2005 Best Practices
This article lists the best practices for SQL Server 2005