sgmunson (7/27/2015)

I see no relevance to the problem associated...

That's probably because the optimizer thinks that the key lookup is more efficient than the index.

You can force the use of the index and compare performance.

Do you have any other process running constantly that might be dropping the linked server?

Or something like this?

CREATE TABLE SampleData(

filename char(3),

col1 char(1),

col2 char(1),

...

Have you tried something like this?

Update TABLE

set LEAD_NOTES__C = CAST( LEAD_NOTES__C AS varchar( 8000)) --Or whatever length you need.

This will remove unicode characters and replace them with a question mark...

Book

Check this for help: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

I'm sorry, I can't help with that because it goes against my beliefs. You shouldn't be storing concatenated values like that. You can generate the string when querying the table,...

I agree that the behavior of SQL Server is unexpected as it interprets the 0.999 as a decimal(3,3) which won't allow integers.

However, if you're using this code, you deserve the...

I saw a truck for this place[/url] this morning on my way to work. I wonder if they serve pork chops as a secret menu item. 😀

We would need some DDL and sample data to try to understand what's going on in here and give proper advice.

This is what I got from your query, but...

You're right. The forum options are limited and the software can be better. I've understood that this happens because this isn't a priority for Redgate and just try to keep...

You could use something like this:

WITH Addresses AS(

SELECT *,

DENSE_RANK() OVER (PARTITION BY BLOCK, STREET, CITY ORDER BY...

You can try this option: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

Does the server have access to the path specified?

You might want to check this thread as well: http://www.sqlservercentral.com/Forums/Topic1300136-392-1.aspx