I will have to respectfully disagree on the notion that partitioning is foremost a management feature, not a performance feature.

There are certainly good management benefits to be had from partitioning...

Hi Jako,

Even simpler than that.

To move a table to a partition scheme you just create or re-create the clustered index.

When you create the clustered index just specify the partition scheme...

Glad I could help Jako, I wish you good luck with your partitioning.

Glad I could help on this Jakodewet.

If all your partitions are going to be on the same spindles then there is no law to stop you housing them all in...

Hi Jakodewet,

I believe that you will still see performance benefits yes, even if all files in the filegroups of the partition scheme are resident on the same spindles.

Obviously performance should...

I've just seen that CU6 is out now anyway, in x86, x64 and ia64 flavours.

In case anyone is looking for this, the x64 binary is now in place alongside those for x86 and ia64.

I don’t mean to state the obvious Tim, but your organisation needs to look at replacing this product and this vendor.

SQL Server 2000 is already out of mainstream support.

If the...

Ah right, I was confused why you had IIS running on the Reporting Services server along with the Reporting Services service.

Obviously IIS is not necessary for Reporting Services 2008, only...

Hi Ravindra, are you using Reporting Services 2005 or Reporting Services 2008?

Hi Ravindra, after some experimentation I did manage to get this working satisfactorily with our existing Cisco infrastructure.

It was possible to configure a probe (I believe that is the correct...

Hi Tim,

One way might be to look in the SQL Server log for the entry which is automatically made after the instance is started.

You will see something along the lines...

Hi Ryan,

If the principal is unavailable and you want to force a mirror to become the principal and to start serving the database to users then on the mirror server...

Hi,

No, it's definitely not possible to use an SSRS 2005 server with an SSRS 2008 ReportServer database.

The schema of the ReportServer 2005 databases is different to that of the...

Hi Patrick,

This configuration works fine, I've implemented it myself.

Prior to doing this I checked with Microsoft to confirm that this configuration was supported and they confirmed that it was.