Now we're out of my area of expertise. On the best way to get more SQL running in less time, your list of three action items are the best...

Your query looks good for finding problem reports. Adding in the byte count was a good touch.

I'm not an...

Here are a couple of threads with suggested solutions that I found by googling the error:

http://www.sqlservercentral.com/Forums/Topic1505442-291-1.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b64bcde9-4769-45df-a8c7-19606c9c33ca/unable-to-drop-subscription?forum=sqlreplication

I'm an advocate for pasting errors into your favorite search engine and seeing what comes...

One thing to confirm is whether the reports themselves are taking a long time, or if the emails are being delayed. I've seen problems where mail clients flag reports...

For me, making the table invisible usually collapses the space it had occupied (using =CountRows() = 0 in the Visibility properties expression for the table). Is there perchance a...

I'm not aware of a way to see the actual transactions that were published. We usually just roughly validate replication using table row counts on PROD vs. the replicated...

Do you mean you've set up the subscriptions and they aren't running, or they've been running just fine but now they're taking much longer than usual? If the latter,...

(Sorry, response in English) If I understand the Google translate correctly, you'll need to add something to your query to also include the sales from a year ago. Here's...

dianerstein 8713 (10/31/2016)

---

Is the report server database stored only on the report server? Can it be accessed by ssis manager 2012? If so, how do you access the report server...

dianerstein 8713 (10/25/2016)

---

I have the following 2 questions to ask about a SSRS 2012 data driven subscription:

1. On a test report server, I am testing the data driven subscription that...

Is there anything in the Visibility settings for the report's detail rows? Maybe the report is just not showing the detail rows. Another thing to check is the...

You can use DATEDIFF for time as well as dates. No need for the conversion - just DATEDIFF(second/minute/hour, In-Time, Out-Time)

https://msdn.microsoft.com/en-us/library/ms189794.aspx

The ReportServer logs should be able to give you a more verbose error description. When I get this error the most common reason is the query is hitting a deadlock.

I'm pretty sure data driven subscriptions are only available in the enterprise edition of SSRS, so different versions on PROD and test sounds like a plausible explanation.

I think in the schedule details if you choose Week and set "Repeat after this number of weeks" = 2, it will run on alternate weeks. The default...