OK here it is .

This table had 35 Million Rows.

We were Updating the BitColumn Field.

There was also a Trigger which would write to another table, which is at...

Unfortunately I am not allowed to disclose more information as a Company Policy.

It is a simple UPDATE statement.

UPDATE <tablename> SET <columnName> = 1 WHERE <datefield> < 'TodaysDate'

And no the <ColumnName> is not part of any Index.

Thanks Gila

Was aware of CLR, was not aware of others. But the CLR was only taking up 8 KB.

Reduced the SQL Server Memory to 58 GB, just to be...

Thanks Craig

I see people have already discussed this. Thanks for pointing this out to me.:-)

I see, I understand what you are saying now.

Then this begs the next question -- how do I know which NON_CLUSTERED index used this CLUSTERED index for "lookups"...

Oh wait a minute Gethyn -- are you trying to say that even though Lookups happen for NON CLUSTERED index -- it uses the CLUSTERED INDEX as a key for...

Ummm I don't think I have made myselves clear here.

All that you guys are pointing out to me is for a NON CLUSTERED index and I understand that, but then...

I understand what she says or so I think.

A lookup occurs when a nonclustered index was used to locate rows for a query, but the nonclustered index did not contain...