Viewing 15 posts - 1,351 through 1,365 (of 3,060 total)
Please take a second look at SoldItems.DateSold, I think this is redundant to Sales.SaleDate. If both pieces of information describe the same attribute which is the date/time of 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.November 5, 2010 at 3:24 pm
Little Nick (11/5/2010)
2. This is because, if there's no data is push from ERP into IntegratedDB, that special program still running. At this...
_____________________________________
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.November 5, 2010 at 3:15 pm
info-849042 (11/4/2010)
_____________________________________
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.November 4, 2010 at 7:04 pm
btodd 61953 (11/2/2010)
_____________________________________
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.November 4, 2010 at 7:45 am
xbarf (11/4/2010)
The only operations on this table are: INSERT and SELECT.
I mean,...
_____________________________________
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.November 4, 2010 at 7:39 am
parissa_bakhshi (11/4/2010)
I don't know much about virtualization. Somebody just told me tha it can take use of other servere which are in your virtual environment.
Yes and 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.November 4, 2010 at 7:04 am
RichardDouglas (11/3/2010)
I promise this isn't spam and I have no connection with Apress
Okay Rich, I'll trust you but... if you keep notifying us about such new releases it will be...
_____________________________________
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.November 3, 2010 at 6:45 am
parissa_bakhshi (11/2/2010)
We have an SQL server instance which have some large databases in it. Most of serer resources consumes for this...
_____________________________________
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.November 3, 2010 at 6:34 am
DNA_DBA (11/1/2010)
There's a document here that shows how the two databases compare from a DBA point of view:
Not your fault but target document is not as good as it may...
_____________________________________
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.November 2, 2010 at 8:38 pm
sasi.tripuraneni (10/26/2010)
Can any one please post Sr level interview questions, its very urgent!
Don't put in your resume anything that can be used against you or better rephrasing it: don't lie...
_____________________________________
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.October 29, 2010 at 2:41 pm
RainbowFfolly (10/29/2010)
_____________________________________
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.October 29, 2010 at 2:21 pm
RainbowFfolly (10/28/2010)
I'd like to include religious holidays in my date dimension as...
_____________________________________
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.October 29, 2010 at 7:50 am
rootfixxxer (10/28/2010)
@GilaMonster
Should it? Always? In every case? Why?
I have little knowledge about developing dw's, but the little thing that i know for example in 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.October 29, 2010 at 7:35 am
Michal222 (10/29/2010)
_____________________________________
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.October 29, 2010 at 7:23 am
feersum_endjinn (10/28/2010)
I think this is what you need:
I would probably do...
SELECT SUM(NVL(qty,0))
rather than...
SELECT NVL(SUM(qty), 0)
...so to ensure individual Null values are summarized as zeros.
_____________________________________
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.October 29, 2010 at 7:05 am
Viewing 15 posts - 1,351 through 1,365 (of 3,060 total)