Viewing 15 posts - 226 through 240 (of 3,060 total)
Tis (8/2/2012)
... tried to query by LDAP. But it does not work.
Would you mind in defining "does not work"?
OID is supported by an Oracle database therefore a SQL Server 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.August 2, 2012 at 9:23 am
I remember developers creating Cognos cubes out of a relational database so the answer would be yes, it is possible.
_____________________________________
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.July 29, 2012 at 3:31 pm
So... reading your detailed defense of your case, you are not suggesting to do Gap Analysis - which is what I do suggest to do, init?
I have to rest my...
_____________________________________
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.July 27, 2012 at 4:41 pm
GSquared (7/26/2012)
PaulB-TheOneAndOnly (7/26/2012)
Lucky9 (7/26/2012)
Could someone please help me with the steps that needs to be followed
when redesigning 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.July 27, 2012 at 6:15 am
Lucky9 (7/26/2012)
I have to redesign the database based on the new business requirementsCould someone please help me with the steps that needs to be followed
when redesigning a database.
Either 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.July 26, 2012 at 12:47 pm
Let me test my understanding of this...
a) Portal is a read-only subset of tables from each database
b) Intake will support an OLTP system
c) Phisical locations appear to be pretty close...
_____________________________________
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.July 26, 2012 at 12:36 pm
As stated count is correct but not the one you are looking for, in that case fix would bt to filter out the unwanted JVM or just divide the result...
_____________________________________
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.July 26, 2012 at 10:29 am
Couple of questions to better understand the scenario...
1- Why two databases e.g. intake and portal? when it appears like one would do the trick?
2- Intake will act as a source...
_____________________________________
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.July 26, 2012 at 10:16 am
SQLKnowItAll (7/26/2012)
However... I could maybe put each customer into their own schema? and build those schemas on their own filegroups? Hmm... Just thinking out loud.
Why don't you push your...
_____________________________________
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.July 26, 2012 at 9:43 am
SQLKnowItAll (7/26/2012)
1. Std. Ed.
Do poor's-man partitioning, a table by customer exposing the bunch as a view joining all of them.
SQLKnowItAll (7/26/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.July 26, 2012 at 8:52 am
You can get the base data needed to create your table from "sp_help table_name".
Data can be loaded into a cursor then a script can be built on-the-fly by adding 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.July 26, 2012 at 8:46 am
SQLKnowItAll (7/26/2012)
PaulB-TheOneAndOnly (7/26/2012)
In terms of restoring a subset of the database I would start by backing up...
_____________________________________
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.July 26, 2012 at 8:40 am
As far as I understand it MongoDB is a non-sql, documents oriented database engine.
In terms of restoring a subset of the database I would start by backing up subsets 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.July 26, 2012 at 8:10 am
Usually Adhoc reporting is allowed against a Data Warehouse not against an OLTP system - is this an OLTP system, init?
Allowing adhoc reporting against this structure might cripple the system...
_____________________________________
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.July 26, 2012 at 7:30 am
devereauxj (4/13/2012)
...Manager's idea is to make sure we capture the data in staging exactly like it is 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.July 23, 2012 at 3:45 pm
Viewing 15 posts - 226 through 240 (of 3,060 total)