the partition table cost is higher than the nonpartition table for the particular column ? is any reason behind on these ?

i created these column as non Clustered index

Use...

hi,

i have changed the clustered index from (id) column to (date) column, Now i am able and create the clustered index after i made the partitioning. but the query performance...

Except "ID" column, I don;t have any primary key column in TableA and all other columns having duplicate values. Moreover the "ID" is the only column which is references key...

is it necessary the primary key should be unique or not reqd ?

because i don't have any other unique column apart from "ID"

thanks & regards

Saravanakumar.R

any suggestion on that ?!!!:)

Sorry i copied wrong error message.

error message is

Msg 1908, Level 16, State 1, Line 1 olumn 'PartCol' is partitioning

column of the index 'cl_ix'. Partition columns for a...

I'm having the existing table around 75million records, which lies in primary file group with contains one clustered and 6 non clustered index columns out of 25 columns in the...

any help on these ?

any hope on these ?

If i make the covering index also i got the same.

thanks & regards

Saravanakumar.R

I have some around 64 Lakh rows and 10 columns

i compared the both the function

Using CTE I got the result on 18 Sec. but there is the...

refer the below like will help you

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

regards

Kumar

Yes, thanks - I made the syntax error.

Yes i recitfied, and run the query but aim is to reduce the Query cost in "Key Lookup" area.

even though i got...

thnaks for your reply. i will check with my store procedure and reply you back Gail.

thanks & regards

Saravanakumar.R

i declared initially

Declare @Rank as varchar(2000)

set @Rank=null

then

Sp'Query

but passing the values is from table.

thanks & regards