Yes - both have the same Clustered Index, the one from where I either update / insert is a Temp table and I create index on the fly every time.

Sure...

Thank you so much Grant for suggestions and Lowerll for the script. I would try that and update you in case of any issues.

Thanks a ton !!

Hello – what you have suspected is absolutely TRUE. Yes – new server is on SQL 2012 whereas the old one is on SQL 2008 R2.

Can you suggest or help...

Yes - I was able to run everything else apart from Script Task.

Thanks !!

Thanks much for the information !!

I have already done the tutorial from MSDN, it was really helpful. Got a basic idea about Tabular Model, now I have been able to...

Thanks for your suggestions Jeff & Jerry.

In my script, only one place we are using OPENROWSET which is in Table Function however this Table Function is being called about 5...

Thanks a ton, I'll try to implement the same in my scenerio.

Thanks !!

Thanks much, that sounds like a best bet indeed 🙂

Well, If you can check the entire thread - that's what my initial plan is however I am just curious if anyone can give me a better idea than having...

Yes, I do have full permissions. It's FULL Load that's why I didn't consider Triggers

My apologies, I should've been more specific about my problem.

I have SQL Job which loads the data into Staging from Source Flat Files using an SSIS Package. I cannot modify...

Link you've provided isn't working, can u pls provide the correct URL as I am in a need of comparing two DBs..

First of all, thank you all very much for your responses. Yes, I am not worried about the data as I am only worried about the better performance of my...

Yeah, I have sent... hope that helps you to work on my issue.

Please let me know if you need any more information on the same.

Thank you, I have sent the script of my SPROC.