Viewing 15 posts - 2,026 through 2,040 (of 3,060 total)
There are a lot of moving parts to consider but I have seen such behavior before.
First you have to prove your point - to yourself, not to me 😀
Take 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.April 22, 2010 at 1:34 pm
John Waclawski (4/21/2010)
he is very willing to show me what he's working on IF[/b] I ask.
so... keep asking 🙂
On the other hand, 90% of the time a DBA has to...
_____________________________________
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.April 21, 2010 at 10:55 am
MG-148046 (4/21/2010)Honestly, I completely forgot about it 😀
No worries - it happens to me all the time 😉
_____________________________________
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.April 21, 2010 at 8:23 am
jaideep.balekar (4/20/2010)
Any help would be highly appreciated.
Something tells me there are two databases because there are two different applications and two different sets of business rules.
Integrating systems is not 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.April 21, 2010 at 6:51 am
parthi-1705 (4/21/2010)
Which is fasterInsert/Delete/Update/Select
how ?
Which is Slower
Insert/Delete/Update/select
why ?
well... it all depends of what you are trying to accomplish... if you want to add a new row to...
_____________________________________
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.April 21, 2010 at 6:44 am
Paul White NZ (4/20/2010)
PaulB-TheOneAndOnly (4/20/2010)
Statement is correct but, it is good to remember PKs are built on top of not-null columns because PKs are there to enforce referential integrity.
While we...
_____________________________________
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.April 21, 2010 at 6:37 am
Trybbe (4/21/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.April 21, 2010 at 6:32 am
may I ask why not "SQL Server Migration Assistant"?
It's free and was specifically designed for Oracle to SQL Server migration.
_____________________________________
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.April 20, 2010 at 3:56 pm
Perry Whittle (4/20/2010)
The thing is the PK is unique (it has to be) but a unique key is a different kettle of fish altogether as it can allow NULLs
Yes!... wait...
_____________________________________
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.April 20, 2010 at 11:17 am
I'm having a hard time to figure out how such environment may provide a valid platform for log shipping testing.
Log shipping is meant to happen in between two servers linked...
_____________________________________
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.April 20, 2010 at 9:48 am
WayneS (4/20/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.April 20, 2010 at 9:04 am
As already pointed - unfortunately - data is gone.
I would review backup and restore histories to check if eventually somebody took a manual backup after the last scheduled one and,...
_____________________________________
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.April 19, 2010 at 6:26 am
Ananda-292708 (4/19/2010)
any luck :crying:
Sorry - we take native backup them let NetBackup to move files to tape. Works like a charm.
_____________________________________
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.April 19, 2010 at 5:38 am
Mohammed Mohsin-392707 (4/16/2010)I am not so good at SQL coding and need your help in writing a SP
Are you familiar with "insert into ... select ... from ... where ..."...
_____________________________________
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.April 16, 2010 at 1:42 pm
Crazy idea... redefine key in target database, make it 22 chars in lenght.
_____________________________________
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.April 16, 2010 at 1:19 pm
Viewing 15 posts - 2,026 through 2,040 (of 3,060 total)