currently we have clustered index on this table (id) columns.

CREATE UNIQUE CLUSTERED INDEX ix_id ON bhanu1(id)

i want to create non clustered index to avoid the index scan

help me how to...

is there a way to find the publisher?

Hi All,

Thanks for your help.

i have few more doubts please clarify it.

1. How to locate that replication publisher ?

2. How to Remove the table from replication ?

Thanks

Bhanu

while i am trying i got the following error:

Msg 4929, Level 16, State 1, Line 3

Cannot alter the table 'ResearchUserAlias_tbl' because it is being published for replication.

Msg 3727, Level 16,...

HI All,

Thank you for your help.

but i need to explain this change.

FROM @entityIds.nodes('/ArrayOfInt/int/text()') Tbl(Col)

can you please explain me why we change

please find the code in detail

IF OBJECT_ID('tempdb..#entityIdList') IS NOT NULL

drop TABLE #entityIdList

create TABLE #entityIdList

(

val INT

)

---XML

DECLARE @entityIds XML

SET @entityIds =N'<?xml version="1.0" encoding="utf-16"?>

<ArrayOfInt xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<int>112350</int>

<int>100886642</int>

</ArrayOfInt>'

---INSERT INTO TEMP TABLE...

i used like this query hint now i got some performance improvement.

please let me know is it valid or not ?

---XML

DECLARE @entityIds XML

SET @entityIds =N'<?xml version="1.0" encoding="utf-16"?>

<ArrayOfInt xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

...

pls find the original execution plan

pls find the original execution plan.

Thanks you very much msmvijayakumar and ChrisM@work.

The given 2 solutions are working fine.

Thanks

Bhanu

if you required more inputs i can provide.

pls share your observations..

thanks

bhanu

Hi Anyone pls help me to get this output.

it is urgent pls.

Thanks

Bhanu

HI All,

TO avoid this issue any database setting to be change ?

i mean ( if we run the query 1st or 2nd time or 3rd time it should show the...

HI Thanks for your reply but the given query is present in a view

i think it wont work in views?

view details:

create view Screen_RatingsData_ProbabilityOfDefault_vw

as

select pd.companyId,...

yes your right if i wait 2 or 3 minutes now i can reproduce the issue ( i mean same time 2 minutes).

thanks for your answer.