Thank You Soooooooooooooooooo much. I got it with Partition

I got the result in less than a min

I do not want any counts i need all the columns and its data like the below format

Ex: I need output like this..

Company ...

Again i'm explaining my exact problem

Hi All,

Splitting a Large table

We have a 30 million + table with 30 fields

as follows

ID

name

job

company

address

city

state

zip

phone

fax

.

.

.

.

.

.

.

.

.

Email

like this we have 30 fields

In the above ID column is...

I did not say that accessing by date.

I mentioned that there is a possibility of adding around 5 lakhs per month.

Only id that is identitity datatype is there

remaining all...

we do not have Date column

Not daily ,monthly 5 lakhs we are inserting into it with the insert statement.

Daily we need to pull the records from that 20Million table.

Table is keep on increasing like this.now...

Ya row ID is unique

5 Million records are duplicates

Thank u So much for all ur sugesstions,

i'll create unique index only

Sample Data is

Id FirstName LastName Address1 Address2 City State Zip .......

20+ columns, Emailaddress

all having datatype nvarchar2(255) except ID Column

Any emailaddress is Ok No priority like...

Insert into New

select * from [37million]

where Rid in(select max(Rid) from [37million] group by email)

or

DELETE FROM [Table]

WHERE [RID] IN

(

SELECT a.[RID]

FROM [Table] a,

[Table] b

WHERE a.[RID]!= b.[RID]

...

Deleting duplicates in that will take long time i guess,

so i want create a fresh table with all the records including non duplicates. once it got inserted , after that...

So it won't create any problem right,

even though if we insert million of records into that in the future.

B'coz earlier we kept Primary key after that insertion process got...

No Email column is not Nullable.

No other primary key or clustered index existing in the table.

This is the first one we are going to put.

Do u mean Unique is better...

Below is the total table with 70 Million records

Total ( Email,FirstName,LastName,Address,City,State,Zipcode,Gender,DOB ,

Phone,WebAddress1,Webaddress2,IPAddress,DateTime,Interest

)

Ofcourse Email is nvarchar(255)

I do not want duplicates in that,...