Viewing 15 posts - 2,611 through 2,625 (of 3,060 total)
Matt (4/27/2009)
_____________________________________
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 27, 2009 at 3:20 pm
Tara (4/27/2009)
yes there was some processing running and the reboot was done according to our shedule.
...why I'm having troubles to digest this statement?
Your options are :
1) Sit tight and 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 27, 2009 at 12:47 pm
What is your SQL Server version?
_____________________________________
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 27, 2009 at 12:36 pm
Alex Rosa (4/25/2009)
SQL Reddy (4/25/2009)
A database can have only one mdf file.So you cannot split this.
opss...I guess the information above is not correct.
It's possible to create more than one DATAFILE...
_____________________________________
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 27, 2009 at 12:32 pm
Check http://support.microsoft.com/kb/307487 ... this is why I love Microsoft's KB
_____________________________________
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 27, 2009 at 12:17 pm
psangeetha (4/27/2009)
I've installed SP3 for SQL server and now when i run SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') I get Productlevel as SP3.
:w00t: shocking!
... sorry, couldn't help myself 😀
_____________________________________
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 27, 2009 at 12:05 pm
http://www.dbasupport.com/forums/forumdisplay.php?f=20 😉
_____________________________________
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 27, 2009 at 9:42 am
tempdb database is actually rebuilt by SQL Server at startup time; message suggests space needed to build it is not available on your storage subsystem.
Make the required amount 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.April 27, 2009 at 9:29 am
Shahrukh Khan (4/25/2009)
We used to migrate stored procedures from dev to prod servers in sql 2000. How do I migrate them in sql 2005?
Assuming you are talking about promoting...
_____________________________________
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 25, 2009 at 12:06 pm
This doesn't sounds like a "Working with Oracle" kind of question.
Eitherway -not considering the merits of the exercise - you can join both tables, load all columns of each row...
_____________________________________
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 25, 2009 at 6:58 am
I'm not that familiar with Oracle express interface.
I would set the proper ORACLE_HOME and ORACLE_SID then open a SQLplus session and do it in one shot.
_____________________________________
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 24, 2009 at 11:59 am
It shouldn't fail; my wild guess is that the batch file has some bad character, look:
oracle [6]:
oracle [6]: cat createtable.sql
CREATE TABLE "TEST45" (ID NUMBER(5,0) NOT NULL ENABLE, DUMMY VARCHAR2(10), CONSTRAINT...
_____________________________________
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 24, 2009 at 11:29 am
Just a couple of questions to better picture the scenario.
1- Is this happening on a well configured database server or is it happening on a desktop/laptop?
2- What can you see...
_____________________________________
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 23, 2009 at 1:33 pm
steveb (4/23/2009)
What criteria defines a bad record?
Usually they are poorly dressed, nervous, don't look you in the eye and just run away when they see a DBA patrol car approaching...
_____________________________________
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 23, 2009 at 12:47 pm
:w00t: hey!...
I'm following the given business specs here, look how they read: "...if recods are equal between 2 tables not to insert, only insert records that are not 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.April 23, 2009 at 12:40 pm
Viewing 15 posts - 2,611 through 2,625 (of 3,060 total)