Viewing 15 posts - 7,276 through 7,290 (of 7,613 total)
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
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...
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 2:45 pm
[Comment below; attempted to edit, instead it was re-posted with edits, so I removed the original comment.]
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 2:44 pm
DataAnalyst110 (7/27/2012)
...
UNLESS they have another Enroll.Credits that is greater than 15.
Did you mean SUM(Credits) > 15 or a single course with Credits > 15?
I suspected SUM but coded it each...
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 2:37 pm
Sean Lange (7/25/2012)
ScottPletcher (7/25/2012)
ALTER TRIGGER UPDate_PONumber
ON dbo.PurchaseOrderDetail
AFTER INSERT, UPDATE, DELETE
AS
UPDATE PON
SET SubTotal =...
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 25, 2012 at 10:12 am
I think the code below should at least be close to what you need (hopefully very close :-)):
ALTER TRIGGER UPDate_PONumber
ON dbo.PurchaseOrderDetail
AFTER INSERT, UPDATE, DELETE
AS
UPDATE PON
SET SubTotal = PO_Total.SubTotal
FROM dbo.PONumber AS...
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 25, 2012 at 9:43 am
sqlnyc (7/23/2012)
What happens if the server has 48GB of memory? Does the OS just ignore it, or is there some way that SQL Server can access it?
Excellent q ......
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 23, 2012 at 1:43 pm
Viewing 15 posts - 7,276 through 7,290 (of 7,613 total)