We have assigned multiple data files for tempdb to both of the following configurations:

1. all on one disk (up to 12 files)

2. split evenly between two disks (up...

Thanks for another superb question Paul.

A couple of things to try. First set WorkingSetMaximum in the RSReportServer.config file. Configure SQL server Max memory.

Here's a link on the WorkingSetMaximum.

This has been of some help...

Yeah - it would be nice to be able to do something like that sometimes.

I think they have...

Good...

Kenneth Wymore (9/19/2011)

---

I, like some others, got the question right for the wrong reason. I focused on the date declaration in the parameters and only caught the renaming of the...

No. You can alter the default values of subsequent dropdowns based on the value of a previous dropdown - but not vise versa.

Does the user that connects your datasource in SSRS have adequate permissions to both databases?

You're welcome.

Lowell (9/19/2011)

---

Based on what Jason pointed to, where you can harvest info from the execution plans, this seemed to work for me;

i ran a proc "sp_find that takes one parameter...it's...

dsbolanos (9/19/2011)

---

I'll take a look and see what I can find, and yeah, I was trying to get something like "exec sp_test 'data1',2, etc..." like what you get in traces...

dsbolanos (9/19/2011)

---

I'll take a look and see what I can find, and yeah, I was trying to get something like "exec sp_test 'data1',2, etc..." like what you get in traces...

Speaking of code on the net, try Glenn Berry's Dr. DMV scripts.

http://sqlserverperformance.wordpress.com/tag/dmv-queries/

Tom.Thomson (9/19/2011)

---

Powercut

----------

At about 9:20 this morning I discovered that the electricity supply was scheduled to be cut of for maintenance/enhancement work from 9:20 to 14:00.

Destroyed my schedule for today....