|Hello every body today no new post today but i will share some amazing and Awesome!! DMV and stored i created it to help me in my daily work really it is very helpful for any Database Administrator|
- Create Clustered Index on all HEAP Tables by on Single Click.
this one of the best DMV for me because it fast the process for me and it is very helpful by this Stored procedure i sued the technique of SQL SERVER DYNAMIC QUERY to loop on all databases exists on my SQL SERVER CLUSTER where this databases is not in system databases and it should be with status online to retrieve from it
- list by all heap tables.
- Loop in this list to retrieve the best column can be Clustered index Based on the criteria that have been developed from my side (Customized option )
- build the T-SQL statment of create clustered index
- Index Statistics for all Databases Exists on your Server
NOW any DBA can return all his index Statistics and save it to decide what he need to do shall i should drop some index (UNUSED INDEX) or shall i should check the index size to take A wise decision we should have the information about the index (last user seek data and percentage , user scan , index size , drop index statement if you need to delete index,..ETC)
For more information and for download DMV check the (POST)