Stefan Krzywicki (8/1/2012)

---

ScottPletcher (8/1/2012)

---

I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought...

I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought it was all...

GSquared (8/1/2012)

---

I agree...

Wow. You must not be a DBA or a data modeler 🙂 .

Stefan Krzywicki (7/31/2012)

---

ScottPletcher (7/31/2012)

---

I admit I haven't...

I admit I haven't used Visio that...

Spend some more time gathering, detailing and verifying your data requirements. Don't worry...

DataAnalyst110 (7/27/2012)

---

Thanks very much to you both.

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,...

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...

[Comment below; attempted to edit, instead it was re-posted with edits, so I removed the original comment.]

Did you mean SUM(Credits) > 15 or a single course with Credits > 15?

I suspected SUM but coded it each...

Sean Lange (7/25/2012)

---

ScottPletcher (7/25/2012)

---

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 =...

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...

Excellent q ......

tim.cloud (7/23/2012)

---

I think your right about that. Not sure if 32GB is the right number, but maybe 34GB for SQL maximum memory which would give the MPA+OS+Other Processes 6GB...