Viewing 15 posts - 2,761 through 2,775 (of 3,060 total)
Vijaya Kadiyala (1/8/2009)
There are no big difference between 9.2 and 9i.
Well... there is a reason for it, Oracle 9.2.* is nothing but Oracle 9i ... so you may expect them...
_____________________________________
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.January 25, 2009 at 12:52 pm
Glad it worked out 😉
_____________________________________
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.January 25, 2009 at 12:45 pm
First thing for you to do is to understand what is management asking you to do.
My wild guess is that you have several SQL Server boxes in your shop 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.January 25, 2009 at 12:43 pm
Some people has fixed the issue by unchecking the "Allow inprocess" option
On SQL Server Management Studio
Server Objects --> Linked Servers --> Providers --> MSDAORA, right click select properties
It wouldn't...
_____________________________________
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.January 17, 2009 at 7:42 am
You are more than welcome David.
I would suggest to go back to management with a report showing a honest estimate of effort and even proposing to do a pilot by...
_____________________________________
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.January 17, 2009 at 7:33 am
Your two primary sources of info for SQL Server are: 1) Books Online -which comes on sQL Server media and, 2) Microsoft Knowledge base -which is free at http://support.microsoft.com/ph/2855
Your post...
_____________________________________
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.January 16, 2009 at 11:41 am
thinknight (1/5/2009)I try to shrink log file to 10 GB
How big was your Log at creation 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.January 5, 2009 at 5:41 am
You have to ensure your databases are available, reliable, and recoverable and their performance meets SLA.
Always remember this: DBA owns the structure but never ever the data.
_____________________________________
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.January 5, 2009 at 5:38 am
Paresh Prajapati (1/5/2009)select t1.A,t1.B,t1.C,t2.D
from table1 t1 inner join table2 t2 on (t1.A=t2.A)
You may want to test your code, unfortunatelly it doesn't work.
I think it will be better to 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.January 5, 2009 at 3:40 am
iqtedar (1/4/2009)
ok ..i will ask him to do...so then what would be the default size of the log file...thanks..
:w00t: It looks to me that you are planning to fix 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.January 5, 2009 at 12:26 am
DBADave (1/4/2009)What else can be done to spped things up?
I would work in fine tunning the application focusing on the most used queries.
_____________________________________
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.January 4, 2009 at 8:52 am
iqtedar (1/3/2009)...one of the developers told me that he created a db with 270Gb assisgned to log file.
Firstly, the root cause of the issue is having allowed a developer 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.January 4, 2009 at 8:48 am
Paresh Prajapati (1/1/2009)5. Monitor TempDB size. If it growth more , then move tempdb to individual disk.
Could you please elaborate on the rationale of the above recommendation?
_____________________________________
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.January 4, 2009 at 1:40 am
What's the Fill Factor for these offending indexes?
Either way, you may want to check the next note about how to defrag SharePoint indexes, here http://support.microsoft.com/kb/943345
_____________________________________
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.January 3, 2009 at 12:09 pm
Chris Harshman (1/2/2009)
PaulB (12/31/2008)
Nice. I'm pretty sure your SOX auditors are loving it, isn't it?
Well, as I've stated previously I'm not really a .Net person, more a database person, so...
_____________________________________
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.January 2, 2009 at 7:26 am
Viewing 15 posts - 2,761 through 2,775 (of 3,060 total)