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...

The solution pointed to by Piet is a good starting point. I'd modify it to do something more along these lines:

SELECT

Catalog.Type,

Catalog.Name,

...

paul.knibbs (8/15/2014)

---

I turned 7 in the middle of 77--I just about remember all the bunting being up for the Silver Jubilee. Can't remember if that was the year that everyone...