Sterling Library at Yale University New Haven, Connecticut. The newly renovated Sterling Memorial Library at Yale University. It’s one of the most awe inspiring buildings in the Collegiate Gothic style. Designed by James Gamble Rogers, it was completed in 1930. It follows the basic form of a cathedral with central nave, side aisles, transept, and sanctuary.