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.

CREATE VIEW x

AS

SELECT * from linkedserver..schema.table

Works great.

Jereme Guenther (10/25/2007)

---

So what is the advantage of OUTPUT parameters over a standard result set? From my experience they are much more of a pain to deal with both...

Unless it's impossible for some external reason, your stored procedure's parameters should always be of the data type that you're attempting to manipulate within the database. So, instead of a...

This is a discussion about the editorial posted today (Friday 10/26) by Steve Jones. Scroll up & follow the link at the top of the comments.