Viewing 15 posts - 166 through 180 (of 3,060 total)
rcjunk (10/28/2012)
_____________________________________
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 28, 2012 at 7:16 pm
As you suspect this is something to be resolved on the application side.
_____________________________________
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 28, 2012 at 7:10 pm
scogeb (10/23/2012)
I don't have an account with them and even after I created one, I still can't find it or don't have access.
Account has to be with Metalink. Oracle's knowledge...
_____________________________________
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 24, 2012 at 6:38 pm
Marlena.ibek (10/23/2012)
My Boss wants me to work from home as well, so what we need to do is to buy good Quality Laptop.
What is the best option?
what kind 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.October 23, 2012 at 8:12 am
CptCrusty1 (10/4/2012)
Here's a question... How many years exp. Should a DBA have to be considered Senior level? How encompassing should the experience be.
I think that defining Seniority based exclusively...
_____________________________________
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 4, 2012 at 1:25 pm
IF what you want to accomplish is to update every single row on CJS table then update should look like:
UPDATE cjs
SET RefreshDate = '20120822 08:00';
_____________________________________
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 4, 2012 at 1:14 pm
scogeb (10/4/2012)
_____________________________________
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 4, 2012 at 1:09 pm
... and the question 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.October 3, 2012 at 6:22 pm
Oracle error "ORA-00942: table or view does not exist" either means that the table/view does not exist OR that the Oracle account a.k.a. userid, used to connect does not have...
_____________________________________
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, 2012 at 1:57 pm
Eugene Elutin (9/21/2012)
dwain.c (9/21/2012)
Still a tie then:
SELECT DAY($)
I thought the Cup is given to whoever comes first...
:hehe:
No if second one hits you on the head with a frypan and runs...
_____________________________________
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 21, 2012 at 7:17 am
sql-lover (9/19/2012)
PaulB-TheOneAndOnly (9/19/2012)
Any chance of doing it during a maintenance window where you set recovery mode to simple? that would keep t-logs from growing.
Hi Paul,
1st, thanks for reply.
I'm afraid...
_____________________________________
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 20, 2012 at 10:50 am
SQLKnowItAll (9/19/2012)
It is possible to get the number of rows affected in a multiple statement transaction without adding the @@rowcount to a parameter for each statement?
As far as I know...
_____________________________________
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 19, 2012 at 1:18 pm
halifaxdal (9/19/2012)
Event ID: 4105: Windows is in Notification period.
I think your Windows O/S has also expired the license... message is consistent with unlicensed O/S
_____________________________________
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 19, 2012 at 12:48 pm
sql-lover (9/19/2012)
Basically, I have 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 19, 2012 at 12:44 pm
Would you please post the schema of both "projects" and "projects3" tables?
_____________________________________
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 19, 2012 at 12:41 pm
Viewing 15 posts - 166 through 180 (of 3,060 total)