What are the advantages, if any exist, of having an an index for every foreign key in a SQL Server database?
Answer
Yes it’s a good practice, see here: When did SQL Server stop putting indexes on Foreign Key columns? scroll down to the Are there any benefits to indexing foreign key columns? section