I figured out this and it seems to be working:

SELECT MIN(vorgcode) as vorgcode, inumerator, idenominator, vshortname

FROM

(

SELECT 'wb_1' as Tabletest, inumerator, idenominator, vshortname,vorgcode

FROM wb_1

UNION ALL

...

First of, i am sorry for not providing the information in correct format secondly thanks a lot for your replies.

I will provide the ddl soon.

create script:

CREATE TABLE [dbo].[tablep1](

[iNumerator] [float] NULL,

[iDenominator] [float] NULL,

[vShortName] [nvarchar](255) NULL,

[VORGCODE] [nvarchar](255) NULL

) ON [PRIMARY]

Insert script:

INSERT INTO [comparison].[dbo].[tablep1]

([iNumerator]

...

My bad, you are right all the rows are different, here is a better data for comparison:

Table1

iNumeratoriDenominatorvShortNameVORGCODE

34146680352107Q1HONDA

28364700343188Q10HONDA

31487900351551Q11HONDA

32852820344581Q2HONDA

33225000351591Q3HONDA

34326200348397Q4HONDA

34644640352002Q5HONDA

34760860351736Q6HONDA

34400420351338Q7HONDA

33943420351899Q8HONDA

33882920349562Q9HONDA

Table2

iNumeratoriDenominatorvShortNameVORGCODE

34146680352107Q1HONDA

28364700343188Q10HONDA

31487900351551Q11HONDA

32852820344581Q2HONDA

33225000351591Q3HONDA

34326200348397Q4HONDA

34644640352002Q5HONDA

34760860351736Q6HONDA

34400420351338Q7HONDA

33943420351899Q8HONDA

43882920349562Q9HONDA

Now the last row is different which would be returned as a result.

43882920349562Q9HONDA

Basically...

Thanks a lot Mark, that did the trick, could you also tell me the best resource/book for sql programming? 😀

Got it Boss,

I will let you know the results, my steps are :

1) upgrade to sp3

2) reduce memory to about 12 gb --- will check results for improvements

3)...

Got your Point jeff,

now i know sql server is :

Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.

This is the message...

Standard edition 64 bit

Hey Jeff,

The SQL server that i am using, its version is as below:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit)...

Thanks for the link,

I already read that, but i first want to try reducing the max value,

so you are suggesting I should make it to 12gb that is...

This is from the Data base logs:

05/20/2010 05:33:14,spid1s,Unknown,A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working...

yes i understand, but the same database on a machine with 4 gb ram only uses about 1-2gb of ram, why is sql server using so much of the...

Thank You Chris, looks like this is the solution, once again thank you so much for your time in helping me out, your the man!

Today, checked the task manager and i saw that sql server service was using 8gb alone,

the min value in mb for memory is set to 0

and the max value...

All i want to do is to remove the duplicate records from these columns:

Columns:

gRightSID(PK,uniqueidentifier,not null) ----> this one has not duplicate record

cRightID(varchar(50),not null)---> if this column has duplicate records...