Well half a second times 250 000 executions = 34 hours of processing.

Improvement here is an understatement !!!!

where the heck are you running that script from? I never saw that before!

You'll find that you can't argue with yourself :P.

Anyhow, I'm sure it'll help someone someday...

Yes I got that, can you post the precise steps to go about doing that so that he can make sure to not screw it up?

So how does that work?

Take a tlog backup.

Run the restore again (maybe as a different db)

Restore to point in time with the log and recover?

Hey Darth. stop reading my freaking mind!!!

or is it the other way around :D.

Since when are the ms dependencies reliable??? God knows they were far from it in 2000. I heard they were working on it, but never got the news...

1 drop constraint

2 drop views, functions, sp

3 drop tables.

That should pretty much work as is. The 2 things that block you from dropping a table are fk constraints and schema...

Here's one, put the clustered index on the DATE. The CI on the identity column is pretty muc a waste in this case.

You might also confirm that adding that...

Where are you gettings those records from?

What do you intend to do with them?

I'm guessing here that this is some sort of dataload since showing 10M records to the users...

doh! talk about a brain fart. I can't see what I was...

Perry Whittle (2/14/2009)

😀 got a feeling he'll be using those...

That's a good point... if no log backup was taken between then and now, you could possibly restore to point in time. That could be a hell of...

I remember doing something like that for a...