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.

Drew Mayo (10/26/2007)

---

Kelvin Lush (10/25/2007)

---

I see nothing wrong with this question. It is basically trying to test whether you are using the ANSI standard JOIN syntax or the older syntax...

I don't have a solution, but possibly an idea.

I live the first few years of my life in a VERY small town in Southwest Missouri called Sarcoxie. For a while...

Sorry, I just plucked it from the middle of existing code. Our system has one table that doesn't have versions and all the rest do. So the query included the...

We also did some this way:

SELECT...

FROM Table x

CROSS APPLY (SELECT TOP(1) whatever..

...

We had a similar problem and solved it, nicely, like this:

SELECT...

FROM Table1

JOIN Table2

on table2.PK = table1.Pk

and table2.AuditDate = (SELECT TOP(1) t2.AuditDate

...

They've already had several instances of "Oh, I forgot to add that WHERE thingie to the query."