Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning FK selection (an nvarchar(30) column or four int columns) RE: FK selection (an nvarchar(30) column or four int columns)

  • June 25, 2010 at 6:30 am

    #1184957

    Eric.Johns (6/24/2010)

    What would be the best thing to do, query performance wise, as far as a FK in my new table, using the 4 int columns or the nvarchar(30) as an FK?

    i would go with stefan but still for concrete results, test it with large volume data.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)