I'd like to ask what are everyone's thought on the use of non-clustered unique indexes.

I've found these useful for the following reason.

Our DBA's re-index on a weekly schedule and the...

Hi Jessica,

2008R2 exposes a lot of datasources. I have a couple of questions though.

1. Do I need to install the software drivers e.g teradata on the Reporting server?

2. Is it...

Has anyone used SQL 2008 Policy based Management to enforce these type of Policies.

Can it be done?

Can it be used with 2005?

Cheers.

And Thanks Jeff for a number of ideas.

Good Idea.

Besides those Jeff has mentioned>

What do you look for?

Hi Aldo,

rather than set a growth figure would it not be better to set the size so all space is taken up on the drive.

e.g. On 40GB drive set each...

Hi Aldo,

rather than set a growth figure would it not be better to set the size so all space is taken up on the drive.

e.g. On 40GB drive set each...

Thanks for the posts, but doesn't answer my question, or maybe I asked the wrong question!

Is it possible to register http://localhost/reportserver/Testfolder in SSMS?

Thanks.

Hi,

I'm planning a scale-out implementation for Analysis and Reporting Services on one environment and database with sql agent on another.

How can I automate backups in this situation?

Thanks.