First thing would be to check what is getting to the Oracle side as a bind variable.

Ask your Oracle DBA to do a 10046 trace at level 4 on your...

That's a very different scenario, isn't it? 😀

Firstly ... ask you Oracle DBA what's the...

Chances are there is a conflic in between replication source and replication target database collation.

If this...

meichner (6/7/2010)We are saying that its is better to combine these 1:1 relationships into one table even though in the vast majority of rows, these extra fields will be set...

firstly... please gather fresh performance stats on SS2K8 affected objects, then try again.

secondly... if issue persists please trace both SS2K5 and SS2K8 versions of the query.

Do you mean... application side errors?

That's a good idea and some of the better designed apps I've bumped into include such a centralized log resource. Be aware this is...

allin1 (6/5/2010)

---

Here are my answers for your questions

1.OLTP (Receving Data dumps, CSVs, Excels, Text files organizing them into DB i.e finally converting them into one standard format and adding it...

Ion Freeman (6/1/2010)

---

I believe...

I gather you have little exposure to data modeling, if this is the case a free resource to get a picture of it can be found in http://www.agiledata.org/essays/dataModeling101.html

Just out of...

or... fix the data.

1st figure it out which PKs are duplicate...

select * from(

select my_primary_key_column, count(*) as headcount

from my_table

group by my_primary_key_column

)

where headcount > 1

2nd...

meichner (6/5/2010)

---

I had been told that all tables should use an identity key. I feel that when someone tells you that you should always do something, that they are usually...

Shall I...

lmu92 (6/4/2010)

---

To add an "it depends" opinion:

I've read that there are cases when a PK-FK relation will help the query analyzer to come up with a more efficient plan. No...

meichner (6/3/2010)

---

I was wondering whether or not I should use an identity column or not in the following senerio:

I have two tables, Sales Order and SalesOrderDisposition. The Sales Order...

There is a documented solution, let me quote: "Beginning with Microsoft SQL Server 2005, you can include Oracle Publishers in your replication topology, starting with Oracle version 9i. "

If this...