Sure... with what?

David,

Now, be gentle with me... just now starting to get my feet wet on 2k5... 😉

...since the following two queries return the identical result set, why did you include "STUFF"...

Unlike Oracle or other RDBMS's, you can do this in SQL Server...

UPDATE CEM_smcsAssignments

SET MGR = a.MGR

FROM #ADD a,

...

Dunno about most of your problems (although sub-queries could be a huge problem if they are actually correlated subqueries), but some...

Are any of the items in the FROM clause actually views instead of tables?

Why? Basically, this is a form of "Death-by-SQL"... where are...

You don't really want to have it reclaim space automatically... causes too much fragmentation over time...

You need to find out what's making it grow to 42Gig... that's step 1...

10 hours to 15 minutes? Heh... I like SELECT/INTO a lot but I've not seen that type of performance gain just by switching like that before... Are you sure...

I load flat files that have many different row types. Fortunately, they're identified by a key in the file. I just load the whole shootin' match into a...

Was it sitting at 42GB a week ago with only .5% used as it was this morning? If so, I think you could probably safely shrink the log file...

What is the datatype of the JobDate column and what does the ChangeDate function return as a datatype?

Heh... I'm getting old... I was looking at trying to...

Mindy, the problem is that you have the data stored in a CHAR(32)... trailing blanks come into play there. Either change the column to a VARCHAR(32) or modify my...

Heh... you must not have looked because I gave you dynamic SQL. 😉

Sorry... not seeing the pattern here between the inputs and the desired output... would you explain how you want the concatenation formed better, please? Also, see the following if...