Viewing 15 posts - 2,731 through 2,745 (of 3,060 total)
jgrubb (2/9/2009)
... but aggregates and functions are different.
Not to mention Triggers, Cursors, Partitioning and stuff that does not exist in the SQL Server world like bitmap indexes, star-transformation, materialized...
_____________________________________
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.February 9, 2009 at 10:55 am
Let me help you with a couple of them...
1. While instalation i am getting one error "restart ur system and install again" ?
Server liked the process that much it wants...
_____________________________________
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.February 9, 2009 at 9:45 am
Oracle documentation is clear, comprehensive and FREE!... check here http://www.oracle.com/pls/db102/portal.all_books
If you have Transact-SQL skills please take into consideration things are not that straighforward in the Oracle side, SQL and PL/SQL...
_____________________________________
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.February 9, 2009 at 8:53 am
:w00t: never got that one. What do you see before and after that error message?
_____________________________________
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.February 9, 2009 at 8:31 am
SQL Server lock resources have nothing to do with how much memory you have in the box.
_____________________________________
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.February 9, 2009 at 7:29 am
1- Take Microsoft training
2- Get certified
3- Get a job as Transact-SQL developer
4- Get an entry level job as SQL Server DBA
_____________________________________
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.February 8, 2009 at 7:00 am
You should be Okay.
SQL Server standard edition can use as much memory as O/S maximun and dynamic AWE support is also available (1).
(1) http://www.microsoft.com/Sqlserver/2005/en/us/enterprise-compare-editions.aspx
_____________________________________
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.February 8, 2009 at 2:16 am
shri_sastry (2/6/2009)
Thanks for the script, how do I know when was the last time the indexes were rebuilt/reorganized. I am trying to come up with...
_____________________________________
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.February 7, 2009 at 3:37 am
David got it covered but I would like to add my two cents.
If you are working in a maintenance window -which means users are not there to bother 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.February 6, 2009 at 10:54 am
Script just processes any index which avg_fragmentation_in_percent is greater than 10%, isn't it?
Question here is... Why?
Those scripts and policies are good for small size databases, not for a 900 Gig...
_____________________________________
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.February 6, 2009 at 10:47 am
It looks to me your transaction got commited.
How about point-in-time recovery?
_____________________________________
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.February 5, 2009 at 4:07 am
No.
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.February 5, 2009 at 1:21 am
LAW1143 (2/3/2009)
The objective is to only rebuild the indices on the data we plan to retain.
we have ~5 years of transactional...
_____________________________________
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.February 3, 2009 at 10:31 am
I'm a little confused because your post first states rebuilding indexes would be impractical because of their size then you are entertaining the idea of bcp-out/bcp-in the whole table which...
_____________________________________
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.February 3, 2009 at 10:05 am
Jonathan Kehayias (2/3/2009)
PaulB elludes to this but doesn't actually make the point clear.
:w00t: mmhhh... I wasn't avoiding -elluding?- the issue and I think my proposed solution is spot on;...
_____________________________________
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.February 3, 2009 at 9:52 am
Viewing 15 posts - 2,731 through 2,745 (of 3,060 total)