Thanks !!!!

How about a Batch delete with batches to delete.

DECLARE @batch INT
SET @batch = 10000 /* SIZE OF BATCH */
        DECLARE...

I'm going for the Delete method...

Thanks for comments...

Or - is this a cleanup effort to remove all of the NULL values and then set the column to NOT NULL?

Yes.

Thanks.

@scott   do you need any more info ?

Thx.

RowCnt              NullCnt

949718305     391584820

Once you've done that, do you have indexes on the FK columns in the tables that are looking at this table?

There are Indexes created.

I have already put code in place to block the NULL values for some of the Attributes, not sure why is was ever code to allow those into the Table....

The date in the table doesn't help much, but the attribute column itself would help in the selection..

Table has 400Million+ records, and I need to keep it online as other processes are updating-inserting...

Any good examples?

Thanks.

Sorry did my Insert wrong should not contain the NULL string should be blank..

Any update Scott?

Thx.

sounds like a plan.

Thx.

Any suggestions?

Maybe that's what I'm trying to ask, how do I only show diff's based upon columns that could be used for sort or key.

Thanks.