how can I run query against all of the register server? can you please send me the query which can be run across all register servers?

Thanks

Lowell (4/23/2015)

---

the order by will not eliminate any rows with the query you gave;

only the WHERE condition does; if you are using a different query than the one you posted,...

Lowell (4/23/2015)

---

since there's an identity in the table, if you change hte order by to that column, do you get the data you want? it sounds like someone updated your...

I was just asking help :crying:

🙁 ok

please view my latest reply and help me please 🙁

Yah I know we have some redundant indexes which was not created by me but one of the person from development team have created those indexes using missing index DMVs...

Thanks for the reply Gila , please view the attached create index script of all these indexes , you can create them in any of your test db or at...

Yah, you are correct and thanks for the quick reply, these indexes were added to the one of our customer’s database that is having issue in performance in May. So,...

Lynn Pettis (6/28/2014)

---

Give this a shot:

declare @ProgamCodeIn nvarchar(10);

set @ProgamCodeIn = N'STORE2';

with baseitems as (

select

ipp.ItemID,

ipp.ProgramID,

p.Code,

rn...

Please view the attached file. My out put should be...

yes I tested that code but its not working below is the result set I got...

SQLRNNR (6/27/2014)

---

David Burrows (6/27/2014)

---

In real db there are only two programs STORE and STORE2 so you should forget...

In real db there are only two programs STORE and STORE2 so you should forget about the other two i.e. UNI and UNI2.

as I told that I will put the...

HI

Is there a better way to write the following ?? Please view the below comments I have received in one of the stored procedure

Plenty wrong. For starters, this

where cast(convert(varchar(10),PostingDate,110) as...