LutzM (9/26/2010)

---

Ouch!! You'd better stop that query....

I was hoping to prea-aggregate AdvStats and reduce the size of that part of your query.

But, unfortunately, it seems like it won't help at...

Yes, absolutely they are heavy tables.

Yeah, I missed out the WHERE clause for it to behave like an INNER JOIN. What do you think was the cause of the SQL...

I don't think the ClientId column is indexed, the only indexed column that I see is the ID of MyTable and this is already an existing design when I came...

LutzM (8/18/2010)

---

If you only need to know if a client id exists use EXISTS instead of COUNT(). See Gail's related blog[/url].

Side note: Is there any index on clientId to...

Hi guys, my bad..I was connecting to a different link server with no address data is present. This is okay now.

Thanks for your help guys. Really appreciate it.

Yes it is the same...here is the sample query.

...

Thanks Steve. I just notice something, OPENQUERY as I tested it actually works but in the reports table, there is an address column of type varchar(50) that I need to...

Steve Jones - Editor (8/2/2010)

---

Depending on what you do, OPENQUERY can be easier to write. If you do a straight join, I believe that the entire table from a linked...

Thanks for the...

Thanks for the help guys, really appreciate it. I think the DELETE CASCADE would help.

Thanks,

James

Yep but I was hoping I could see some sample implementation on how to do script for this one.

Thanks.

Nabha (1/21/2010)

---

Script all the sps (Obj exploere->right click on db -> tasks -> generate script) from a database, store it in one single sql file, open it in the...

Thanks Adi and Jeff for the prompt response. Will look/research into these suggestions you posted.

James

Good point there ALZDBA, since those are the only columns that exist on our db table..there should be index in where you can determine the latest one. I just wonder...

Nabha - Thank you for your prompt response. Well the result is not what I want, I just need to get the last value of the columns Message and Description...