--Create non clustered indexes for all foreign key references in the database
SELECT 'CREATE NONCLUSTERED INDEX [IX_' + tablename + '_' + columnname +'] ON [dbo].[' + tablename + '] ( [' + columnname + '] ASC)'
FROM 
(
    --Script all foreign key columns that are not already an index      
--    SELECT
--        o.name AS tablename, cols.name AS columnName FROM sys.foreign_key_columns fc
--        inner join sys.objects o on fc.parent_object_id = o.object_id
--        inner join sys.columns cols on cols.object_id = o.object_id and fc.parent_column_id = cols.column_id
--    EXCEPT 
        SELECT o.name AS tablename, cols.name AS columnName FROM sys.index_columns icols
            inner join sys.objects o on icols.object_Id = o.object_id
            inner join sys.columns cols on cols.object_id = o.object_id and icols.column_id = cols.column_id 
        where icols.index_column_id = 1
) T 
ORDER BY 
    tablename, 
    columnname