GilaMonster (2/22/2012)

---

That's reorganise. Rebuild...

It depends on so many factors, including where the burden of the processing is occurring.

Grab an execution plan both from the local server and the remote box and compare...

Is the Poll added by mistake?

What code are you using for the .csv and what code are you using for the Excel spreadsheet?

What you posted isn't too clear because...

Transact-SQL, also known as T-SQL.

Kiran,

Thank you for providing DDL code, INSERT statements, and a expected result, but I don't know your data well enough to understand what you mean by "modify".

Please be more clear...

This question needs more clarification.

How are the parameters being populated?

What about the report? Is it an auto-run or is it printed upon request?

I'm not sure about the rest...

Please post DDL code, a sample data INSERT statement, and what code you're already using to achieve your current solution. That will help us test any advice we give you.

Also,...

You may have a bad install file, but on the off chance that you don't, check the following:

Available disk space (is it enough for the setup files?)

Attributes of the cab...

Well, okay. There's still a non-Replication method around this.

Depending on your edition, you could use Log Shipping or Data Mirroring to get a readable version of a secondary server. Log...

GilaMonster (2/22/2012)

---

Question for those of you who have organised SQLSaturdays

Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had...

In addition to the previous comments, I also advise running PerfMon on the 2005 server to see if the hardware is at capacity or not.

If you're starting to see...

I've never used third party tools for replication.

Question, though. This secondary server requirement for always online... Is it because you're using it as a report server?

What do the setup logs say?

During the blocking, is it always specific indexes that are having this problem?

If so, you might be able to do the majority of your indexes during that time and then...

inconceivable