How many rows does this return?

SELECT COUNT(*) FROM hbincome ...

I just saw Gail's post, I guess that's why I can't get this to work >>>

--this needs to run in 2 steps

--step1

GO

CREATE DATABASE TestRecov_SSC

GO

ALTER DATABASE TestRecov_SSC SET RECOVERY FULL WITH...

What happens if the job doesn't run??? I think that goes beyond performance!

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