Viewing 15 posts - 2,281 through 2,295 (of 3,060 total)
1- Please check cardinality on affected Oracle tables.
2- Please describe available indexes on affected Oracle tables.
3- Check execution plan on Oracle side.
4- Ask Oracle DBA to do a '10046 trace...
_____________________________________
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.October 2, 2009 at 6:47 am
mmmhhh... scenario description it's not clear enough - depending on interpretation it may be working the way it's supposed to work.
Could you please simplify to just two tables and show...
_____________________________________
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.October 2, 2009 at 6:41 am
ItalianOlgi (10/2/2009)I have very good memory,I can study and memorize everything, I want to find a good job, make look like I expert on SQL Server.
Build your own lab....
_____________________________________
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.October 2, 2009 at 6:24 am
Unfortunatelly you will have to script credentials, jobs, etc. on source server then apply scripts on target server.
_____________________________________
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.October 2, 2009 at 6:14 am
Roy Ernest (10/1/2009)
PaulB-TheOneAndOnly (10/1/2009)
Roy Ernest (10/1/2009)
Please keep in mind that just because it is primary key, it has to be clustered.
mmhh... not entirely true.
Statement holds true only if 1) 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.October 1, 2009 at 1:48 pm
Question would be... why you want to have FKs on those replicated tables pointing to a different server? Parent-Child relationships are already validated at the source 😉 ...
_____________________________________
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.October 1, 2009 at 1:13 pm
Roy Ernest (10/1/2009)
Please keep in mind that just because it is primary key, it has to be clustered.
mmhh... not entirely true.
Statement holds true only if 1) No clustered index already...
_____________________________________
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.October 1, 2009 at 1:09 pm
Good.
Take the ten top queries you expect to hit that table, look at the predicate a.k.a. where clause and build indexes based on what you see.
As a rule of thumbs...
_____________________________________
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.October 1, 2009 at 9:35 am
Post suggests there are two different issues here.
1) "Sharing" a table in between different schemas or the same database.
2) "Sharing" a table in between different databases located in different servers.
In...
_____________________________________
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.October 1, 2009 at 9:04 am
Viky (10/1/2009)
I have a doubt because the fields are varchar type, Does not generate problems if I have index of fields that are varchar type?
No. No problem at all.
How...
_____________________________________
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.October 1, 2009 at 8:58 am
manohar-718845 (10/1/2009)
will size matter while rebuilding index ?
Yes, it does. A 300K index is really a small one.
_____________________________________
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.October 1, 2009 at 8:55 am
http://msdn.microsoft.com/en-us/library/ms143506.aspx You gotta love Microsoft documentation, don't you?
_____________________________________
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.September 30, 2009 at 2:52 pm
dsohal (9/30/2009)
I used to Backup the Database in SQL 2000 and then truncate the Log File and later shrink the log File to free up the space
:crying: shhhh... tell nobody,...
_____________________________________
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.September 30, 2009 at 2:09 pm
:pinch: shall I understand you are asking how to build indexes on Server-B pointing to tables sitting on Server-A?
_____________________________________
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.September 30, 2009 at 2:04 pm
After you bounce SQL Server link works fine for some time then it hits again; is that a fair statement?
If Yes... something is getting corrupted over time, memory leak perhaps?
_____________________________________
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.September 30, 2009 at 2:00 pm
Viewing 15 posts - 2,281 through 2,295 (of 3,060 total)