More than one indexes on same column in SQL server

If we create one more non-clustered index on a column which already have one in SQL server, what Would be the effect of that?

Yes, you can do it. But either more indexes on a column or the use of a non-clustered index in a table may decrease the performance.

The effect is judged at runtime based on your search condition.

http://logicalread.solarwinds.com/duplicate-indexes-and-sql-server-performance-nh01/#.VWP8JUaWvQA

SQL Server: multiple index for the same columns performance

Create more than one non clustered index on same column in SQL Server

SQL Server creating multiple nonclustered indexes for one column vs having multiple columns in just one index