Tom.Thomson (2/11/2011)

---

YG&LF!! I started reading the stuff at that URL, and hit...

sqldba_icon (2/11/2011)

---

Ninja's_RGR'us (2/11/2011)

---

Unlikely. The problem with this setup if that you are basically downloading the whole table.

Unless you can bring that down to 3% and ideally very much...

ZA_Crafty (2/11/2011)

---

I started my career as dba, and in the mean time discovered that my true calling is in fact development.

Now if my dba disables select * from any of...

Unlikely. The problem with this setup if that you are basically downloading the whole table.

Unless you can bring that down to 3% and ideally very much less than...

Without a where condition it CANNOT do anything else than a scan.

That being said, maybe it's not required.

Can you post table / keys / indexes defs, sample data and required...

Yes there is. Simply put a default parameter that has a fast completion time. So they know what the report will look like.

Here's a very complete list of...

My setup is in french so guess-translating.

You have the same function to hide the folders as you have for the reports. Which means you see hit in the full...

Well that starts with correct cataloging and classification in folders.

That being said, you could put all your subreports into a single folder and hide that folder from the "short" list...

I understand but what are you trying to prevent???

What's the worst that can happen if a user unwantedly runs those subreports bypassing the parent?

Yes... otherwise you'd have no way to go in to edit the properties.

You could always add a hidden parameter that you set via the parent report so that even if...

Ya just go in the subreport properties in the web interface and then check the box "Hide in list view"

Grant Fritchey (2/10/2011)

---

Ninja's_RGR'us (2/10/2011)

---

kasaranenikiran-725528 (2/10/2011)

---

THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also...

doodlingdba (2/10/2011)

---

Thanks for all the ideas guys!!

Maintaining two datasets is an inefficient way of doing things - but my data source is SSAS and i'm new to MDX so I...

kasaranenikiran-725528 (2/10/2011)

---

THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to...

clare.xia (2/9/2011)

---

Wow.. I can't believe I got all the attentions from SQL Gurus! This is a great learning experience for me!

Here are the references I have been using. Please...