If you are passing the same parameter value for each run then parameter sniffing is not the issue.

Still it looks like the processing time on the report server is the...

The attached execution plan doesn't include the UNION. A UNION ALL there if you know there are no duplicates would help some. Also your execution plan doesn't show...

Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:

Sean does a have point, but, I'd say that a 35 million row insert might be better done batched, but I'd do an explicit transaction for each loop of the...

Q1: I'd try to use the same deployment process as used for other artifacts in my company. For example, if a deployment utility is used to deploy applications,...

You might want to check out SQL Power Doc[/url] by Kendal Van Dyke. It's a free collection of PowerShell scripts/modules that finds and documents SQL Servers. You could...

T-SQL probably isn't the best tool for this job. This is something that I'd use SSIS for.

But, having made my disclaimer, you can probably do it in...

You can change many, but not all, sys.configurations settings by right-clicking on a connected server in SSMS and selecting properties then navigating through the different pages making changes needed.

I'm pretty sure that isn't possible. Unless the sub-reports are called by other processes I'd probably replace the sub-reports with 2 data regions (tablixes) and 2 datasets in a...

I'd probably do this with SSIS and put the process in an agent job that runs on set schedule.

Steve Jones - SSC Editor (8/21/2013)

---

Nadrek (8/13/2013)

---

We also share responsibility:

DBA's handle Database<->Disk and disk retention/aging, automated and ad-hoc and PITR.

Backup team handle Disk<->Backup software (disk and tape), automated and ad-hoc,...

Koen has provided some very solid advice (as usual).

I have a degree in Physical Education and have never taken a computer science class, although I have done some of the...

I don't think there is anyway to control this within SSRS if you are using the Date control, I believe it is something controlled by the browser.

I'm not sure that the query you provided is doing what you think, unless the Start Date and End Date passed in are based on the data frequency meaning when...

Yes, I have seen the same problem, but you can't use dynamic sql inside OPENQUERY because OPENQUERY doesn't allow the use of variables. From BOL:

OPENQUERY does not accept variables...