Viewing 15 posts - 2,641 through 2,655 (of 2,838 total)
I'm also not a DBA, though lately I've been doing some DBA things in addition to my normal work.
However, like Alvin, I normally like to work with the DBA to...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 7:58 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's one of those non-DBA...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 7:13 am
Others have already mentioned there's no easy way to do this and you have a lot of work in front of you. I'd like to add that you should take...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 26, 2010 at 5:24 pm
Alvin Ramard (8/26/2010)
WayneS (8/26/2010)
Stefan Krzywicki (8/26/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 26, 2010 at 1:28 pm
CirquedeSQLeil (8/26/2010)
The argument on what is history is: I just want to be able to change the data if I want to.
At that point, I'd tell them flat out...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 26, 2010 at 11:59 am
CirquedeSQLeil (8/26/2010)
Stefan Krzywicki (8/26/2010)
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?
Data integrity didn't work
Point in time visibility did...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 26, 2010 at 11:54 am
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?
Data integrity didn't work
Point in time visibility did not work
Reporting consistency...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 26, 2010 at 11:33 am
djdhere (8/25/2010)
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 25, 2010 at 3:05 pm
Brandie Tarvin (8/25/2010)
Alvin Ramard (8/25/2010)
Someone replied with:
How do you get a PK violation?
Are you inserting the PK values yourself?...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 25, 2010 at 12:21 pm
GilaMonster (8/23/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 24, 2010 at 9:56 am
GilaMonster (8/23/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 23, 2010 at 2:09 pm
GilaMonster (8/23/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 23, 2010 at 10:30 am
Steve Jones - Editor (8/23/2010)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 23, 2010 at 10:17 am
GilaMonster (8/23/2010)
Steve Jones - Editor (8/23/2010)
I would run a log daily just to clear out the changes from that day.
Unless there's something that mandates full recovery (mirroring/log shipping) I'd just...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 23, 2010 at 10:15 am
GilaMonster (8/23/2010)
Weekly full, daily diff right after...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 23, 2010 at 10:14 am
Viewing 15 posts - 2,641 through 2,655 (of 2,838 total)