Heh... thanks, Donald... I just knew there had to be something else... maybe even some DELETE triggers somewhere in there that no longer fire due to the Truncate...

Anyway, thanks for...

Ashwin M N (12/18/2007)

---

I want to make clear about what my application developer wants.

create table test1 (A1 int identity(1,1),A2 datetime)

insert into test1(A2) select 19-12-2007

create table test2 (A1 int identity(1,1),A2 datetime)

insert...

Mike Levan (12/18/2007)

---

when i tried doing this

select startDate from tblemp where startDate between '1/1/2006' and '12/31/2006'

i dont get that date range, why?

startdate is varchar(100), I Cant change that in the...

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...