Viewing 15 posts - 7,276 through 7,290 (of 7,619 total)
It should be, it's a temporary work db, just like tempdb :-).
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 20, 2012 at 8:47 am
You don't need to take a log backup if the db is in simple recovery model -- indeed, you can't: SQL doesn't allow a log backup to occur while the...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 20, 2012 at 8:27 am
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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),...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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 🙂 .
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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,...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 27, 2012 at 3:58 pm
Viewing 15 posts - 7,276 through 7,290 (of 7,619 total)