Viewing 15 posts - 7,261 through 7,275 (of 7,602 total)
Since their current log drive is full, they are in a tough situation.
Without a DBA there, to me the safest thing to shrink is a temp db.
It could try to...
August 17, 2012 at 1:26 pm
mr.neil.bryan (8/17/2012)
Would shrinking this database file resolve our issue?
Possibly.
Since it is the Reporting temp db, if you have a lot of free space in it, I would go...
August 17, 2012 at 12:43 pm
GSquared (8/2/2012)
Don't assume that your opinion, unbacked by data, is going to convince people of anything. Repeatedly asserting "Erwin>Visio" without any sort of analysis at all...
August 2, 2012 at 8:45 am
Stefan Krzywicki (8/1/2012)
You still haven't defined what you consider a complete modeling tool. Or what it requires beyond the "very nice pictures" you mention.
Yes, I did. To repeat, separate...
August 1, 2012 at 1:03 pm
GSquared (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling),...
August 1, 2012 at 12:11 pm
Stefan Krzywicki (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought...
August 1, 2012 at 9:40 am
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought it was all...
August 1, 2012 at 9:28 am
GSquared (8/1/2012)
ScottPletcher (7/31/2012)
Stefan Krzywicki (7/31/2012)
When I had the choice between Erwin & Visio, I chose Visio.
Wow. You must not be a DBA or a data modeler 🙂 .
I agree...
August 1, 2012 at 8:33 am
Stefan Krzywicki (7/31/2012)
When I had the choice between Erwin & Visio, I chose Visio.
Wow. You must not be a DBA or a data modeler 🙂 .
July 31, 2012 at 2:01 pm
Stefan Krzywicki (7/31/2012)
ScottPletcher (7/31/2012)
Stefan Krzywicki (7/31/2012)
Scott, What does Erwin have that Visio doesn't that causes you to consider it a modeling tool while not considering Visio one?
I admit I haven't...
July 31, 2012 at 12:46 pm
Stefan Krzywicki (7/31/2012)
Scott, What does Erwin have that Visio doesn't that causes you to consider it a modeling tool while not considering Visio one?
I admit I haven't used Visio that...
July 31, 2012 at 10:33 am
Lucky9 (7/26/2012)
redesign database based on the new business requirements ... steps need[ed] ... when redesigning a database.
Spend some more time gathering, detailing and verifying your data requirements. Don't worry...
July 31, 2012 at 9:58 am
DataAnalyst110 (7/27/2012)
Scott, I'm going to go with yours because I can better understand what it is doing. (By the way, I didn't need the SUM,...
July 27, 2012 at 3:58 pm
Tempdb drives are much too small. SQL uses tempdb a lot, and you can't afford to run out of tempdb space.
I would not dismiss RAID5 for the db data...
July 27, 2012 at 2:45 pm
[Comment below; attempted to edit, instead it was re-posted with edits, so I removed the original comment.]
July 27, 2012 at 2:44 pm
Viewing 15 posts - 7,261 through 7,275 (of 7,602 total)