The Option i was thinking is while we are receiving the file from the vendor we use FTP to do that i was thinking of renaming the file to truncate...

Thank you .I do not want to take the date part because we get the file once a month and we are not sure we will be importing the file...

Hi Lowell

We have a History table but like Emp is my current table and EmpHistory is our History table .

Emp Table only have current table and EmpHistory has...

Thank you very much

the Index's seems to be the same in both the environments.

But the MAXDOP is different because our environments are set up like that

and so i was using Option...