I'm not aware that replication, generally, is being deprecated any time soon. While there may be other, better options, in SQL 2012 to achieve your requirements, if you need...

Do you actually have the replicated DB online Jeff? I've used a couple of flavours of SAN replication but the database is not actually mounted at the other end

ESpigle (8/16/2012)

---

We are wanting to setup a second read-only database server that we replicate to to help load balance for some specific applications that will be fairly intense with...

I missed RECEIVE too. I have to say not a lot of work has gone on in our office this...

uncle_boris (8/7/2012)

---

Or would I have manually restore this file onto the secondary database and then the log shipping job would look for the next file that would have been created...

Thanks Gianluca

The reason I was veering away from parameter sniffing is that this problem occurs even when the procedure cache is clear. I had considered the OPTIMIZE FOR query...

A very large transaction will cause the log to grow. There isn't anything you can do to 'deal with it' apart from ensure you have sized the transaction log...

Not sure how 'automated' you need this process to be? If you're able to generate the snapshot then go in and manipulate the relevant .sch files before running the...

cascade-enterprise (8/10/2011)

---

Any chance anybody found a resolution to this? I have the same problem and even granted execute permission to the procedure for the specific user account in question...

All local. The issue scales with volume anyway and the particular query is largely irrelevant. A query that runs <1 sec on the test box takes 23 seconds...