I suspect as much, which is a far bigger stuff-up than dropping schema names from procs.

nataliehinnen (4/30/2009)

---

One of the issues with specifying the owner is that when a developer is developing a stored procedure, they would have to be logged in as “dbo” in order...

Offhand, no, but I suspect it has something to do with Statement level recompile and/or temp table caching. I...

WayneS (4/30/2009)

---

There's an article coming out soon (ask Steve, not me, when that will be) that will tell you everything that you need to know in comparing table variables to...

Please. I...

You do know that your link in that thread is broken?

Excluding, of course, creation of any constraints or indexes

With the same table that I used earlier, I make it

Table 'Users'. Scan count 1, logical reads 269, physical reads 0

SQL...

Oracle Express has a web interface. i was using that. I think I'll find something else to use now.

That's one...

This may be of interest to you.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

ALTER TABLE Users ALTER COLUMN UserName VARCHAR(42)

From Books Online (page on CASE)

All of the columns you specify in the CASE...

True. That's what I get for posting while playing computer games....

Frank Carrelli (4/30/2009)

---

The Query Plan does look solid except for two Key Lookups on two different sub-select statements. They are not using the indexes we originally created for those select...

SELECT CustomerID,

MaxCommentDate

FROM Customer INNER JOIN

(select Max(Comment.CommentDate) AS MaxCommentDate, CustomerID

From Comment

Where CommentType = 1

GROUP BY CustomerID) AS Comments ON...