Whoops, attachments added.

Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table. ...

You'll immediately see the problem query in the original execution plan doing the 1.14 billion rows between the Table Spool and the Nested Loop

I was hoping there'd be a "Oh you just need to do it this way" by looking at the code...but knew I'd get dinged on the lack of preparation on...

I don't fully understand how this works to detect changes at the table level. BOL states that 'ALL' is the default value yet using 'ALL' doesn't work when you...

Winner Winner Chicken Dinner 🙂

Thanks a million man! Working like a champ!

Not sure I follow you (sorry) or I am not communicating my intent properly.

This is a server that has the default MSSQL service and SSRS service already installed; and works...

To clarify, I am trying to use multiple SSRS instances on a single database instance

I'm in need to accomplish the same thing on a SQL 2008 install. I installed the second reporting server instance...successful.

But how to set it up?

I don't see a 2nd...

Thanks a lot for this, had to create an index on the larger table been hit but it does work well!

I had to completely disable replication altogether and start over.

In retrospect, I believe if I had run the distribution cleanup agents prior to attempting to re-add the publications, it might...

Not sure if this helps or not but basically an rss file consists of a few basic "chunks":

1. Declarations

2. Parameters Collection

Full Rss File Example:

'Report Config Parameters

Dim format as string =...

Short and sweet!:-)

Did you ever get this working?

I typically made the following changes:

1. Change the file growth settings from percentages to fixed growths of 512MB (or 1GB depending on what the server is used for - and...

Both good recommendations, I really appreciate it!