i am attaching the execution plan and this plan has a Index Scan in it as it only uses a DateTime index as im not enforcing it to use any...

Dear thankyou very much for such a quick response and your valuable information but unfortunately i have tried all these and i have index seeks not a single index scan...

Paul White gave the best solutions which is implementable on Large table in a very efficient way.

if you need any kind of explanation i will be more than happy to...

I am really thankful to you it really solved my problem. Thank you !

I will be looking for more from you thanks.

I am really thankful to you it really solved my problem. Thank you !

Even Better !

you are a really great Help for me. I will be glad to discuss more thing with you.

Thanks again !

Thankyou Very much ! I have got it. Its a great pleasure for me.

Thanks again.

First of All I am really grateful to see your valuable reply.

If multiple users come at the same time and there is no explicit BEGIN so multiple users will get...

Its a PK.

Its unique

The row with Text Mashrafe M is a duplicate but its like some of the exceptions as the data on both the rows in not identical but I just need...

ID,UserID,VisitorID,Text,TimeStamp,ViewCount,MetaKeywords,MetaDescription,PageURL,CategoryID,LocationID,Status,MisplacedCount,SpamCount,InappropriateCount,MarkedAsMisplaced,MarkedAsSpam,MarkedAsInappropriate,DiscussionCount,ExpertCount,IPAddress,ProxyAddress,IsFeatured,ExpertID,ExpertName,ExpertURL,Source,SourceURL,QuestionDescription,ListingDescription,SuckerID,SuckerType,LastDiscussedTimeStamp,RowVer,IsUpdatedByAdmin,LastUpdatedTimestamp

19311982,NULL,135879,how 2 make,2009-02-06 01:53:01.327,4,NULL,NULL,how-2-make,NULL,1061209,1,0,0,0,0,0,0,0,2,117.96.132,117.96.132,0,NULL,NULL,NULL,NULL,NULL,on weblo, ,on weblo, ,NULL,NULL,NULL,0x00000000066827D9,0,NULL

19311981,NULL,135696,Mashrafe M,2009-02-06 01:44:24.553,3,NULL,NULL,Mashrafe-M,NULL,1841404,1,0,0,0,0,0,0,0,0,172.16.20.,124.109.39,0,NULL,NULL,NULL,NULL,NULL,Mashrafe M,Mashrafe M,NULL,NULL,NULL,0x00000000066827AF,0,NULL

19311980,159,NULL,A strange ,2009-02-06 01:38:18.527,3,NULL,NULL,A-strange-,NULL,1841404,1,0,0,0,0,0,0,0,0,172.16.20.,124.109.39,0,NULL,NULL,NULL,NULL,NULL,Sea life -,Sea life -,NULL,NULL,NULL,0x00000000066827A6,0,NULL

19311979,NULL,135696,what is so,2009-02-06 01:32:20.053,2,NULL,NULL,what-is-so,NULL,1841404,1,0,0,0,0,0,0,0,0,172.16.20.,124.109.39,0,NULL,NULL,NULL,NULL,NULL,Mashrafe M,Mashrafe M,NULL,NULL,NULL,0x0000000006682765,0,NULL

19311978,NULL,135696,Mashrafe M,2009-02-06 01:28:25.220,3,NULL,NULL,Mashrafe-M,NULL,1841404,1,0,0,0,0,0,0,1,0,172.16.20.,124.109.39,0,NULL,NULL,NULL,NULL,NULL,Mashrafe M,Mashrafe M,NULL,NULL,2009-02-06 01:41:00.000,0x0000000006682799,0,NULL

19311977,159,NULL,which site,2009-02-06...

sorry I am unable to get your point please explain again !

let me explain you again.

e.g.

If there are 10 rows then its possible to have 4 rows with one same question and 6 other rows with another same question.

then there...

Column1 is the Text Column

Column2 is the Source Column

I need to concatinate both the columns and then need to Remove the duplicates

The rows are complete duplicates all the data is...

The Column1 i.e. Text contains questions and I need to find unique questions and there are different questions in it and duplicates as well so I just need to delete...