I admire your teacher. This homework problem actually sounds like a bit of fun to solve rather than the usual library or shopping cart examples.

But the other guys are right....

We can't hate the UK. They have really good beer.... Let's blame France instead. Their beer sucks.

Jack Corbett (4/28/2010)

---

CirquedeSQLeil (4/28/2010)

---

Tom.Thomson (4/28/2010)

---

That's right.

And you got in fast there Jason,...

2cams (4/29/2010)

---

Hi Guys an update ...

The Tempdb is staying at the 35Gig mark. We are happy to leave it at that size as it is not growing to fill the...

Nope. INSERT/DELETE/UPDATE operations are done one table at a time.

You can wrap it all in one transaction,...

I am not joking when I say, this looks like the example code I use to demonstrate why RBAR (row-by-agonizing-row pronounced rebar) queries are slow.

Yes, walking through a set of...

lmu92 (4/28/2010)

---

Grant Fritchey (4/28/2010)

---

People here may not have, or may not want, StackOverflow logins to answer your question. If you want an answer here, ask the question here. Otherwise, wait...

izdede (4/28/2010)

---

Thanks so much for your reply.

I set up the perfom from my machine. I select the computer I want to monitor by select remote computer to run perfmon...

I'm sorry, I can't understand entirely what you're describing.

Why can't you use referential integrity?

BTW, you mention a view that enforces integrity. Views are simply select statements. They can't enforce integrity...

Without more details, it's kind of hard, but basically, assuming TableA is the parent and TableB & TableC have foreign key relationships to the table, and that the column that...

At this juncture, I'd go straight to 2008 R2, skip 2005 and 2008 entirely.

As far as the upgrade process, if you can, the safest way to do it is...

Maybe it's just me, but it sounds like you just need to delete stuff off the server.

If this location also has your data files, one thing to look for is...

Ninja's_RGR'us (4/28/2010)

---

Grant Fritchey (4/28/2010)

---

Ninja's_RGR'us (4/28/2010)

---

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out...

only4mithunc (4/28/2010)

---

Thanks every one.

So do you mean to say, if the table has an index (on the column on which WHERE condition is applied ) the above order of execution...

Ninja's_RGR'us (4/28/2010)

---

Grant Fritchey (4/28/2010)

---

I can't tell you specifically why truncate is allowed and not delete when you give the alter permission, but you're wrong about rollbacks. Truncate can be rolled...