Let me take a wacky guess...

http://www.yohz.com/products_sqlverify_restoreverifyonly.htm?source=ssc

I'm not sure if it helps but I have ssrs 2005 SP4 here and the back button in IE 8 brings me back to the parent report in its state...

What's different between the 2 environements?

If you can reattach to the original server, then it means the db files are fine... and that it's a permission issue.

This error can mean 2 things, either the server doesn't have read / write access to that folder. Or the file already exists.

LutzM (3/28/2011)

---

mattias 58533 (3/28/2011)

---

Hi all experts!

I have a machine that needs to be tuned perfectly.

My questions: Are there any good sources/ebooks how to do this from the start?

We don't have...

No offense intented, but I run reports that basically read from 50% of the data in the whole freaking...

Make a calendar table, select the range from that table and then left join on attendance and students

Just consider the ressources required to find / hire a competent DBA (especially with noone around to tell you what a good candidate looks like).

It might be eaiser to hire...

I'd take Gail's forum advice any day...

Define slow, and how much data are you displaying?

Ok, then how about reducing from 100K to 1K queries?

Why the heck do you have so many transformations to go through?

This is not automatic, but usually when you have 2 dbs like that, you also have 2 servers. So the speed increase is almost automatic.

Even if you keep it...

It means all the columns required to run the query are in the index.

That means columns from the select, joins, where, group by, having, order by....

are all contained in the...

reread the 1st paragrapgh... can't be much clearer than that.

What are you not understanding?