Viewing 15 posts - 691 through 705 (of 3,060 total)
David Lester (12/9/2011)
Thankfully, after years of attempts, IT has ceased to be a wall. While they are still not ready to listen to me, they...
_____________________________________
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.December 10, 2011 at 3:58 pm
Let's keep it public meaning, no private messages unless you are planning to hire me 😀
So... as per your message the idea is to keep the data of all 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.December 10, 2011 at 3:53 pm
andychurry (12/9/2011)
_____________________________________
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.December 10, 2011 at 7:24 am
cochran1010 (1/10/2011)
Creating a new table with the key from the sales data, and fields for the flags is the best option rather than addition.
Do you realize we are talking dimensional...
_____________________________________
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.December 8, 2011 at 2:51 pm
Long time ago I saved the recipe below - credits to Nathan (no last name) who was the original poster. Let me quote:
In BIDS, do the following:
1.Click on Report...
_____________________________________
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.December 8, 2011 at 2:42 pm
gopalchettri (12/8/2011)
The scenario is as follow:
ERP is web based application so there will be many different organization going to use it.
1. Yes: ERP modules need...
_____________________________________
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.December 8, 2011 at 2:37 pm
sun37 (12/7/2011)
Dev (12/7/2011)
sun37 (12/7/2011)
then the attribute isCountry (country_code, country_name)
Army (army_code, army_name, country_code)
Solders (name, ID, rank, country_code)
Don't you need to connect Army with Soldiers? Think 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.December 8, 2011 at 2:15 pm
john_nyasani (12/2/2011)
_____________________________________
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.December 8, 2011 at 2:04 pm
Lynn Pettis (12/8/2011)
Depending on what you are trying to accomplish, using cursors may not even be necessary.
I'm pretty sure this is homework, that's why I'm just pointing poster's nose 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.December 8, 2011 at 12:42 pm
Olalekan Adewale (12/8/2011)
- My approach of updating the table is truncate and load, what other best approach...
_____________________________________
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.December 8, 2011 at 12:40 pm
ashisht4u (12/8/2011)
DECLARE @emp_num VARCHAR(30)
DECLARE @begin_date DATETIME
DECLARE @end_date DATETIME
DECLARE cur CURSOR
SELECT emp_num, b_date, e_date...
_____________________________________
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.December 8, 2011 at 12:27 pm
Derek Markel (12/7/2011)
_____________________________________
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.December 8, 2011 at 11:57 am
RuanK (11/16/2011)
I have logged a SR with Oracle
I think that's the sensitive thing to do.
By the way, have you checked Metalink note #370921.1 "ASM - Scalability and Limits"?
_____________________________________
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.December 8, 2011 at 11:53 am
smohammadnia.3840 (11/27/2011)
windows server is 64 bits and ole db providor is 32 bits one
Please take a look at this: http://sqlservercorner.blogspot.com/2009/03/linked-servers-for-64-bit-sql-2005-sp3.html
_____________________________________
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.December 5, 2011 at 5:17 am
Lowell (11/29/2011)
i thought ALL concatenation in Oracle must use double pipes
You are correct Lowell.
_____________________________________
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.December 3, 2011 at 4:06 pm
Viewing 15 posts - 691 through 705 (of 3,060 total)