Viewing 8 posts - 1 through 8 (of 8 total)
I cant set the OPTION(FORCE ORDER) in the IF EXISTS clause
In the SELECT only Statement ist works fine
SELECT * FROM dbo.ATEMP_tblExportArchiv ATEA INNER JOIN dbo.tblExportArchiv AEA ON ATEA.EA_GUID = AEA.EA_GUID...
May 19, 2009 at 10:03 am
Hehe a little error in reasoning,
your right, thx for the broad hint
but thats not the real cause. I want to know why it doesnt work?
In the actual situation its...
May 19, 2009 at 9:10 am
Hi Jack,
thx for the answer.
the reason why i used this structure is, that i think an INSERT without WHERE (1st Statement) clause is faster than an INSERT with...
May 19, 2009 at 8:39 am
I'm sorry, but *.sqlplan is a not permitted type, so I packed both Files in a *.zip File.
tblExportArchiv (841142 Sets) is the Archiv Table - tbl1
ATEMP_tblExportArchiv (217716 Sets) is...
May 19, 2009 at 7:20 am
thx for the answer
Theres no improvements if i change NOT EXISTS clause to EXISTS. For simplification i replaced the INSERT Statements with PRINT's and still get the high duration
May 19, 2009 at 5:41 am
For drop article from the subscription you need to execute:
1. sp_dropsubscription
2. sp_droparticle
For adding the article after update
1. sp_addarticle
2. sp_refreshsubscriptions
to add the article you can also take the enterprise Manager...
July 27, 2005 at 9:48 am
thx for the answer,
but thats not the way we want to go, because the same replication works by other customers.
I thought while the snapshot agent runs the tables are locked...
May 10, 2005 at 10:07 am
Viewing 8 posts - 1 through 8 (of 8 total)