I would like to add to this question. I have something similar (except for all the joins). A program on this one computer shows that a single select...

What you listed sounds reasonable. Here is the specs of one of my Production SQL servers that is running on a VMWare machine. It has 2 Hyperthreaded Cores...

There may be a way but I am not aware of one. I have done an FTP job inside of an SSIS package, SFTP was not an option with...

Yes, I would make the Emp_Id column on the other tables the foreign key. They link back to the Primary Key of Emp_Id on the Emp_Name table.

nsmith 8448 (2/12/2013)