You are right Allen. We have separate  files for Data,Indexes and Logs.Primary file group is the Data file. The huge table has clustered Index (in the form of PK Constraint...

sorry gor getting late to you as I was with my MGR proving before we open up Microsoft case.

Melvin, the count(*) is higher than Select * as u guessed.

But the...