Thanks Gail!!! Now I understand what you are saying about the non-clustered index. However,asmall doubt remains as in the above example, as you said, if am trying to add RowID...

Here comes a question,

Say my tale has the following structure:

(

RID varchar(20 - 20bytes

TAID Bigint - 8 bytes

...

I was just trying to convey like whats the significance of unique key while creating indexes. To me, while I was checking with DBCC IND and PAGE, I could see...

Okei, thank for your post. I found something very interesting as below:

I just changed the post little bit to have a better reading....(oops fed up with formating the same...)

In our...

Most probably due to you scema binding is missing...plz check

Even i felt the same in one of my projects with many extent fragmentation too. Use SHOWCONTIG and check the fragmentation.

I am not sure of what you are trying to do. Anyway, guess the below will lead you to try something....

Declare @SQL Varchar(500)

Set @SQL = 'Select Employee_Id,col3 From Employees'

Select Replace(substring(@SQL,CHARINDEX(@SQL,'Select...

Will the below help you?

Select A.name,B.name From sys.objects A

Inner join sys.columns B On A.object_id = B.object_id Where A.object_id >50

Order by A.name asc

Appreciate any thoughts on the same!!!

replication needs an identity column create new identity column in both servers.

Check the following things:

1. the mentioned site, did they use any where condition?

2. Are you querying from the same server or over...

Hi Jeff, Thanks for your comments to look at the different angle of the DM.

Yes, I can see fragmentation and fragments also in the scenario. So can we take...

Non-clustered index with clustered index, table will be sorted based on indexed column and non-clustered indexes will point to the index key of clustered index and finally the data page....

Am I missing something in my question? Any thoughts?

Multiple rows are your problem. Just put a top 1 in your sub query. However you need to evaluate the business logic.