Viewing 15 posts - 2,941 through 2,955 (of 3,060 total)
joyce.staszewski (9/12/2008)
Would it be better to add files to the existing Primary group and then rebuild the indexes to balance the data across the files?
If you are planning in having...
_____________________________________
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 12, 2008 at 5:52 am
It looks like you have a DNS issue, name resolution.
Can you ping the server from the station using DNS name?
_____________________________________
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 12, 2008 at 5:48 am
Glen (9/11/2008)
_____________________________________
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 12, 2008 at 2:34 am
Glen (9/11/2008)
I totally disagree.
Business requirements specify where you have to go, no how to go there.
In ideal world? Yep. In reality? ...
After all: the design of the DWH will...
_____________________________________
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 11, 2008 at 1:00 pm
Glen (9/11/2008)
Design of a DWH using relational model or cubes should be defined by client's requirements
I totally disagree.
Business requirements specify where you have to go, no how to go there.
_____________________________________
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 11, 2008 at 10:59 am
1- You can start with Books Online, chapter 1.
2- Think twice before doing anything then, when you are totally sure step back and think about it one more time.
3- Always...
_____________________________________
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 11, 2008 at 10:53 am
Shark Energy (9/11/2008)
... a web app with hundreds of users you would be better off with the processor license.
Yes.
You can also research Microsoft ISP licensing.
_____________________________________
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 11, 2008 at 10:30 am
:w00t: You are only mentioning Kimball... that's blatant discrimination!!!
If you mention Kimball you are required by law to mention Inmon... -or was it Inmoff? 😀
_____________________________________
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 11, 2008 at 10:26 am
Alvin Ramard (9/10/2008)
Point a webcam at the abacus and you can have mirroring; or would that be replication?
mmhhh... neither one, if you loose your primary-abacus-site you would have nothing at...
_____________________________________
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 11, 2008 at 2:42 am
Welcome to the Oracle world.
PL/SQL and Transact-SQL are totally different languages like French and Occitan are meaning, do not expect to be fuent in one of them just because 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.September 11, 2008 at 2:35 am
Alvin Ramard (9/10/2008)
Backup of the abacus would be easy. Just take a picture and store it in a safe place.;)
That would be good for DR... you can send 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.September 10, 2008 at 9:13 am
Michael Earl (9/10/2008)
In both definitions, the final...
_____________________________________
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 10, 2008 at 9:00 am
Sandra Skaar (9/9/2008)I have two databases, let's call them DB1_Production and DB1_Test. Both of these databases have the SAME physical file names AND the files are in the same location
Prove...
_____________________________________
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 9, 2008 at 9:56 am
Nicely done. Congrats!
_____________________________________
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 9, 2008 at 5:41 am
vundisrinivas (8/28/2008)
What are the steps we should take to increase the capacity and performace of the report server.
1- Capacity planning
2- Capacity monitoring
3- Figure it out if more resources are needed
4-...
_____________________________________
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 9, 2008 at 4:41 am
Viewing 15 posts - 2,941 through 2,955 (of 3,060 total)