Any help would be highly appreciated. I have SQl 2012 with 16GB RAM and a 10 MILLION record table. I am merging everyday the whole 10 million records. I know its bad practice..but this is DEV and i am purposefully doing this. On SQL 2012 with 16GB RAM(Memory allocated for SQL Sever is 12GB), its taking 10 min and the same time with the same query on SQL 2014 with 256GB RAM. the memory for SQL Server is 160GB(for SQL 2014). Are there anyadmin level changes that i need to do for better performance? I have restarted SQL Server more than 2-3 times.