• Do you have Huge tables?

    Do you use lookups to join those tables.?

    Is your server 32-BIt and which SQL Server Edition do you have? ENT/STD/.