Well, I imagine the indexes are emptied, if that's the right word, when the table is truncated.

An index on 0 rows will not contain much!

Note having (nonclustered) indexes in place...

If you can recover the primary server intact, it will rejoin the mirroring session as the mirror, and start synchronising from the principle.

You can fail back to it if required...

Can you drop & recreate the group Login?

Reading this, I kind of get the idea CHECKSUM is bad to use...

http://www.sqlservercentral.com/blogs/steve_jones/2009/06/01/sql-server-encryption-hashing-collisions/

HashBytes might work for you though. Alternatively, could you build a Full Text index on the column?

I'd add that if you're using a named instance, as you seem to be, port 1433 is unlikely to be the correct port.

To elaborate: port 1433 is what the default...

No worries. Think the behaviour is that report deployments (or saves when using Report Builder), don't overwrite the parameters' default settings.

Hi, is the report cached or a snapshot?

Does the updated value show correctly if you run that SQL in Management Studio?

Cheers

Hi Tim,

As I understand it, you're editing the defaults in Report Builder only?

If you edit the parameters in Report Manager directly the change should stick.

Cheers

I think that might be an OS/browser issue rather than SSRS.

Rather than holding the rendered report in RAM, could it be paged to disk once the window's minimised?

Delay could be...

Hi Douglas,

I can't see the screenshot - could you try and attach it to the post?

Think I can understand what you're after but should be able to help more if...

Yeah, I did the same!

It's actually the Row Group you need to set it on.

Think the KeepWithGroup option needs to be set too for it to work.

Hi Wendy,

Do you mean the path the file is stored at from a Windows file Share subscription? If so, check the Subscriptions table in the ReportServer database.

If you mean from...

Hi, unfortunately not. You need to create the shared data sources in your report project in BIDS.

The projects have no knowledge of what's on the report server itself.

Data sources will...

No problem mate 🙂

Something like this: ISNULL(NULLIF(RTRIM(val),''),0)