Viewing 15 posts - 1,336 through 1,350 (of 3,060 total)
Nope.
User creation may be one of the less intrusive activities I can think about.
In our shop we have to have an approved Change Ticket to touch production, only...
_____________________________________
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 9, 2010 at 2:34 pm
I'll check the overall load in that timeframe - concurrency may be an issue but most probably I/O contention.
_____________________________________
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 9, 2010 at 9:28 am
Little Nick (11/8/2010)
GSquared (11/8/2010)
I normally do ETL through SSIS, not through an external XML file, but it sounds like it should work, if I'm understanding you correctly.
How about data integrity?...
_____________________________________
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 9, 2010 at 5:25 am
YSLGuru (11/8/2010)So in closing it’s a question of not who should be responsible for making sure the recovery gets done but who should be the lead to investigate the issues...
_____________________________________
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 8, 2010 at 1:37 pm
This is like discussing why pigs get fat... answer is simple, it is not the pig's fault but the fault of whoever feeds the pig!
In the environments I control 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 8, 2010 at 1:13 pm
YSLGuru (11/8/2010)
PaulB-TheOneAndOnly (11/8/2010)
YSLGuru (11/8/2010)
Anyone In a mixed (non-Native SQL) Recovery setup who best to take the lead on investigating errors
Always remember Rule #4 which states "DBA are responsible for database...
_____________________________________
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 8, 2010 at 12:54 pm
bill 36362 (11/8/2010)
SQL Express in not throttled. It does however have some limits. It only addresses 1GB of Ram adn 1 CPU and max db size is 10GB.
I agree...
_____________________________________
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 8, 2010 at 12:50 pm
YSLGuru (11/8/2010)
Anyone In a mixed (non-Native SQL) Recovery setup who best to take the lead on investigating errors
Always remember Rule #4 which states "DBA are responsible for database recoverability" so,...
_____________________________________
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 8, 2010 at 12:38 pm
C# Screw (11/8/2010)
PaulB-TheOneAndOnly (11/8/2010)
Lets pray vendor doesn't drop or change the name of "NAME" column 😀Yep that would c#Screw it all right:-D
So no probs otherwise then ?
That's what I...
_____________________________________
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 8, 2010 at 12:35 pm
As Ray points it out there are a lot of questions to be asked.
Most important questions I would ask to myself if I was in your position is:
- Is...
_____________________________________
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 8, 2010 at 9:15 am
Lets pray vendor doesn't drop or change the name of "NAME" column 😀
_____________________________________
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 8, 2010 at 9:05 am
Chan Wai Yin (11/6/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 7, 2010 at 7:05 am
parissa_bakhshi (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 6, 2010 at 6:00 pm
bickling77 (11/6/2010)
Here is my revised ERD with if someone could give me some input on this I would greatly appreciate it.
mmhhh... still seeing SoldItems.DateSold column. 🙂
_____________________________________
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 6, 2010 at 4:38 pm
Pac123 (11/5/2010)
Thats right..Table B is at a more granular level than table #A. [one record for every week in the date range between start and enddates].
Here is the root cause...
_____________________________________
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 4:47 pm
Viewing 15 posts - 1,336 through 1,350 (of 3,060 total)