SQL Server

How to list all SQL Server indexes?

How to list all SQL Server indexes? It can be very useful to display all database indexes to have an idea at a glance at how this SQL Server database is optimized with indexes, whether CLUSTERED or NON CLUSTERED. This query offers you a synthetic list of indexes. If shows