bcp is not very format friendly.

how do i extract data from yesterda using replication ? whgat about the format? and i want it to extract to txt files.

bASICally i just...

U gotta use profiler n performance monitor to test the performance.

http://www.esri.com/news/arcuser/0102/files/SQLProfiler2.pdf

http://www.perfassoc.com/jsc/pdf/papers/nt_performance_paper_97.pdf

write that 100+ times?

how to prevent this?...they told me the tables should be drop at anytime.

I issue was I did not have the SP4 installed.

I have both servers on SP4 now and It's working fine now.

Looks like restarting the server solved the issue. Strange.

Matt Miller (4/17/2008)

---

escaleraroyal (4/17/2008)

---

Jeff Moden (4/16/2008)

---

escaleraroyal (4/16/2008)

---

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that...

Jeff Moden (4/16/2008)

---

escaleraroyal (4/16/2008)

---

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing the...

I hope this helps.

exec dbo.asp_UPDATE_INSTRUMENT_WORKFLOW 2008, 1, 1

/****** Add modified update instrument workflow stored procedure ******/ create PROCEDURE dbo.asp_UPDATE_INSTRUMENT_WORKFLOW @year...

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing the issue as company1...

Thanks matt for your response

Hey listen the vendor tested the application1 using the same database in his company's pc and it's working OK for him. That means it's not the application1.

We have lots of...

ssis

Interesting post. I wonder why the variable made such as improvement to the query.

Beautiful.

Thanks.