wait type found is "CXPACKET" . This is because of an insert statement to temp table "insert into #tmp as select ........"

What other parameter should I consider and move further...

Grant Fritchey (7/3/2015)

---

If the execution plans are the same then it's likely down to resources. Take a look at the waits statistics before and after the run in order to...

Thank you Gianluca Sartori

Done with book download

Thank You.

Do I have to consider any thing before executing following ?

Will it take more time to reconfigure?

will database be available to connect during this activity ?

Do I...

Thank you

Thank you Erland Sommarskog.

I got the same link.

I was curious about its impact. Whether I have to generate and embed it to app or just install it and it may...

Thank you.

I was so confuse as on internet people are saying binary_checksum cannot guarantee to find differences but hashbyte is much accurate.

As we have seen examples , it seems it...

thank you britton.

Following worked. I was not aware that XML column becomes case sensitive while selecting.

DECLARE @testXml XML;

set @testXml=

'<invoices>

...

Thank you Lutz.

I will take care of oracle stuff, just...

I have used 2nd option but having following error....

Thank you Lutz.

RPC with Execute worked.

second option you have mentioned is use to insert records in Oracle from local MSSQL object ?

a free tool with option to customize

http://www.apexsql.com/sql_tools_refactor_features.aspx

Phil Parkin (12/23/2013)

---

You could also try forcing transaction commits in your WHILE loop:

WHILE @@rowcount > 0

BEGIN

begin tran

INSERT INTO tblPricingExc2 --table tblPricingExc2 has an Identity column as PK.

( Key ,

Flag ,

Id

)

SELECT...

Thanks Phil.

Begin and Commit tran worked. Does this avoid logging ?

I have insert and Update . No delete required.