Categories
Scripts

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 so I came up with this script. Let me know your views.

Categories
Performance Tunning

SQL Server 2005 Best Practices

This article lists the best practices for SQL Server 2005