But wouldn't you be able to just restore from the full backup (say from the night before) and then the Tran Logs up until you started the process...

or if...

Yeah very true, I'd first try Bulk logged.

But if the only process going on in the re-index I see no harm in switching out into Simple mode, apart from...

You could create a job to change your recovery model during the process then switch it back to full mode after and fire off a full back up.

select cardno

,CAST(datetime1 AS DATE)

, MIN(cast(datetime1 AS time)) AS MINdatetime1

, MAX(Cast(datetime1 AS time)) AS maxdatetime1

from view1

GROUP BY cardno, CAST(datetime1 AS DATE)

Give that a try.

J

Yeah Good call that.

Create VIEW V2 as

SELECT

cardno

, MIN(datetime1) AS MINdatetime1

, MAX(datetime1) AS maxdatetime1

,[action]

FROM (

Select * FROM view1)A

GROUP BY cardno, [ACTION]

I think this is what you are after.

you could take it...

Take a look at this http://stackoverflow.com/questions/6775384/sql-server-single-query-memory-usage

J

Have you checked Run in 64 bit Mode?

Worth a check.