Viewing 15 posts - 1,876 through 1,890 (of 3,060 total)
tomiboy59 (6/9/2010)
Well I am working on replicating from an Oracle database to my SQL Server database.
That's a very different scenario, isn't it? 😀
Firstly ... ask you Oracle DBA what's the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 9, 2010 at 3:02 pm
tomiboy59 (6/9/2010)
Well, I am trying to set up replication, but I get collation errors.
Chances are there is a conflic in between replication source and replication target database collation.
If this...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 9, 2010 at 12:33 pm
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 7, 2010 at 4:27 pm
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.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 6, 2010 at 8:19 am
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 6, 2010 at 8:15 am
allin1 (6/5/2010)
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 6, 2010 at 7:44 am
Ion Freeman (6/1/2010)
itsmeman (1/5/2010)
what advice would you all have to not using cursors if youhave sensitive data that needs to be checked to maintain its integrity?
I believe...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 5, 2010 at 1:31 pm
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 5, 2010 at 1:17 pm
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 5, 2010 at 1:02 pm
meichner (6/5/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 5, 2010 at 11:53 am
sgalbra (6/4/2010)
The execution plan in 2008 did mention a missing index, and after building that new index my timing problem was solved. It didn't change the execution plan.
Shall I...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 6:22 pm
lmu92 (6/4/2010)
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 6:09 pm
meichner (6/3/2010)
I have two tables, Sales Order and SalesOrderDisposition. The Sales Order...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 1:29 pm
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 1:22 pm
You are correct, Pro*C is Oracle specific.
On the Windows/SQL Server side of the world research ESQL/C - short for "Embedded SQL for C". You can start here... http://technet.microsoft.com/en-us/library/bb463140.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2010 at 6:03 am
Viewing 15 posts - 1,876 through 1,890 (of 3,060 total)