So it just ignores the FG2 reference? The fact that it essentially corrects the developer's mistake is great, I guess, but shouldn't the engine inform the developer that it's...

john.arnott (10/16/2009)

---

Actually, yes. I've been going through a database...

I guess I need to learn to read a little more carefully. My apologies. However, I must take one final whack at this dead horse. The fact...

I see your point but I'm not really sure I agree with...

While I like this type of question in theory, apparently, in this example "efficient" is defined only in the context of how many bytes are being stored. When asking...

Allocating memory doesn't necessarily mean that it will use memory. It simply means that it can. As the data and proc cache fills you will see the amount...

My bad. I forgot that I had turned on "discard results" last week while testing something else.

blandry (8/19/2009)

---

Our parent company implemented a plan about a year and a half ago where new hires are brought on for a 6 month probation period, during which they are...

I've been out of work for four months although I'm (finally) starting a new job on Monday with a great company. During that four months I've experienced a wide...

The answer given is incorrect. SQL Server Express does not support reporting services. SQL Server Express Advanced edition does.

GilaMonster (4/8/2009)

---

Robert Frasca (4/8/2009)

---

Actually, if memory serves, in SQL Server 2005, table variables are stored in TempDB as well. In SQL Server 2000 they were stored in RAM. ...

GSquared (4/8/2009)

---

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables, and that temp...

"all temp tables are bad" and "all sub-queries are bad"

The temp tables thing comes up a lot.

I was once doing some performance tuning for a client and encountered a query...

Thanks for everyone's suggestions. As it turned out, it was embarrassingly simple and, as sometimes happens, I was trying to make it harder than it needed to be.

UPDATE TempFactTable

...

Gianluca Sartori (3/11/2009)

---

Try this:

UPDATE TempFactTable

SET CodeID = LookupID

FROM TempFactTable t

INNER JOIN (

SELECT LookupCode, MAX(LookupID) AS LookupID, MAX(OtherCode) AS OtherCode

FROM LookupTable

...