LutzM (8/9/2014)

---

You've mentioned to expect between 10 and 50 rows as the result set.

However, the actual execution plan returned more than 280.000 rows.

Are those rows really returned?

Or is there usually...

GilaMonster (8/9/2014)

---

Reordering of joins won't do a thing,...

[font="Comic Sans MS"]Thanks! Gail. I'll look into it, and post the actual exec plan after updating the stats. It's been quite sometime when we last updated the stats with full...

[font="Comic Sans MS"]Hi Gail,

Thanks! for your prompt response. I'll try and add the table definition & index definition (maybe the...

[font="Comic Sans MS"]Thanks! LutzM for all your help till this point.

- The views are encapsulated with a whole bunch of other queries referencing some other tables, and again those...

[font="Comic Sans MS"]Thanks! LutzM. However, its kinda difficult for me to run that query again and get the actual exec plan...so for the # of rows returned is around 280093...

Do you have a script to check if it's primary or secondary? Could you pls. post it in case if you have one.

Regards,

Faisal

Hi Steve,

I already said that it's read only for secondary. I am only concerned whether I could run a job from secondary and if yes then it should not fail...

Hi Perry,

Its been set to read only but not read-intent (I mean the application doesn't have this option yet) the job is still failing on the secondary, and as said...

Thanks! Perry....but then you're asking me again to migrate the objects which isn't what I want to do. Basically, all I want to do is an in-place upgrade.

Regards,

Faisal

Yes...that is absolutely correct. Do you think by any chance this is a possible solution.

Regards,

Faisal

Hi Grant,

Sorry if that was confusing but I am not installing new servers. It's just that to complete a 2 node cluster setup I would require one more server with...

Thanks! homebrew01. Is it a mandate that for setting up replication your require a linked server. Secondly, the key column "id" is unique and I need to compare using this...

Hi,

Can someone update me on this? I bet someone might have done this in the past. Pls. I need someone's help on this asap.

Thanks! mascot but this doesn't really answer my question. Pls. share your thoughts/experience about this stuff. I'm sure there might be people in this forum who might be knowing about...