wow. that's a long time.

The table is about 50M rows. we're running DL385 with 16GB ram.

I knew I can do that. I was wondering if there is a way to do this differently, perheps using alter index.

I have the same problem. The files just stay there.

I intalled SP1 today hoping it would resolve the problem, but it does not.

The logs say the plan ran successfully, but...

Thanks guys for quick response.

If (Update) will work great for me.

You can use dateadd/datepart to calculate # of seconds in a day and add that to 0 date.

The below example would return: 1900-01-01 18:01:06.000

declare @x dateTime

set @x = '2006-4-13 18:01:06'

select...

The stored procedure inserts into multiple tables. One of the tables needs only the date as it checks if a record with that date exists (and other fields) and updates if...

I would think this would be slower than DateAdd solution as this converts to varchar and back.

I found a solution on google:

SELECT DATEADD(dd, DATEDIFF(dd,0,@x), 0)

but that seems odd to do datediff and dateadd to get the result.

I wish there was a built in function for that.

thanks, I know that now.

At one point few months back, the automatic backup failed for few days and the file grew quite a bit and I couldn't find a way...