Something like this could work:

DECLARE @string VARCHAR(1000) = 'this is a string with some non-printable characters at the end '

/* 67 characters including spaces at...

clayman (8/18/2014)

---

Thanks for your response.

The result sets returned for those data sets are different (number of columns returned / data types) so not sure if it's possible to do...

I assume you mean non-printable characters like Carriage Return or Tab?

How are you running the report, in BIDS or deployed to a report server? I'd recommend deploying it to a report server and testing performance there. You can...

I guess this is "simpler":

WITH addedFieldValue

AS (

...

It looks like the query itself could use some work, but I won't start there.

Basic indexing strategies are to have your index keys be columns that are involved in filtering...

Good points thus far. Something I think you need to take into account is that you have asked for contracting rates, not consulting rates. Contracting rates will be...

If you read the 1st link in my signature and post using those suggestions you'll get more and probably better answers because what you have posted so far doesn't really...

The error means that the data type for ASUP_ID (according to the metadata) has changed either in the input or the output of the task and by clicking "Yes" the...

This behavior is part of the standard and should not be affecting the results of your query. I recommend you read these 2 articles:

http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/%5B/url%5D - which is old, but...

As far as index sizes, there certainly are cases where an index can be nearly as large as the base table itself, and I'd argue that if that is the...

Just thought of something, that might help you, but because I don't know how you are consuming the data in report. Here's the idea:

1 data set that returns the...

You can't do that natively in SSRS. Each data set in a report is executed whenever the report is run. SSRS doesn't currently support multiple result sets. ...

I'd never leave a database file autogrowth setting at 1MB. The smaller the growth size the more physical fragmentation the file will have on disk. The next physical...

I think there are some potentially simpler options:

1. If you have connectivity between sites you could look at setting up mirroring and then "failover" to your mirror when everything...