happyme_01_cool (10/30/2007)

---

I just thought id try it out, n i came up with

SELECT dbo.course.cname, dbo.enroll.classno

FROM dbo.course INNER JOIN

...

Nice job Gail.

Talk to you later Sandy.

That's a really interesting wind power generator. The cost does look interesting. We're already off the grid for heating the house (outdoor wood burning furnace), water and waste disposal, so...

Michael Fried (10/29/2007)

---

That was one of my initial thoughts as well but I think there are a number of issues that prevent using a file:

* Concurrency Problems - there will...

Save it to disk with the extension .sqlplan. You can then reopen it as a graphical execution plan.

2005 has a more granular time field internally. It deals in micro seconds instead of milli seconds. That might explain it. It still stores datetime fields as milliseconds. I had...

It's just a series of joins & where clauses. If you've paid any attention in the course, you should be able to do this stuff. If you get stuck on...

Oh that's all right. You have one too. 😀

Sandy (10/29/2007)

---

Hey Grant,

Can you have a look on to my last post..

I will be happy if you and jeff will have a

sharp eye on my post.

Thanks a lot for...

Honestly, one table... Why put it into a relational data management system? Assuming at least a good primary key, this can be accessed faster from a file than from the...

Everyone else has covered this for the most part, but I don't mind adding one bit of information. Table variables, unlike temporary tables, do not have statistics created on them....

Very best way to log all calls to a database is through SQL Profiler (also called Trace).

Table valued stored procedures do not generate statistics. This means if you are going to join one function to another or anything else along these lines, performance won't just be...

Bob Fazio (10/26/2007)

---

End Users should not have access to direct SQL. PERIOD! If it is a reporting system some visual tool yes, but not SSMS.

Developers should have read...

Hey, nice trouble shooting pattern. I'll have to see if we can begin to apply that one.