if not exists (select * from sys.indexes where name = 'IX_ConnectionGroup_GroupName' AND object_id = object_id('dbo.ConnectionGroup'))
    create index IX_ConnectionGroup_GroupName on dbo.ConnectionGroup (GroupName) include (ConnectionID)