okay; found this was to do with the Dark theme....

https://connect.microsoft.com/SQLServer/feedback/details/910798/ssis-annotations-in-ssdt-2013-invisible-in-dark-color-theme

hmmmm.... no one seems to have answers for you, and afraid I don't yet, but....

just installed SSDT-BI for VS2013 and upgrading SSIS packages from SSIS2008 to SSIS2014...

annotations are apparently now...

UPDATE STATISTICS + sp_updatestats = 2 statements!

🙂

I had the very same question, here's a post which discusses why local variables cause problems with matching to filtered indexes:

http://blogs.msdn.com/b/timchapman/archive/2012/08/27/the-drawback-of-using-filtered-indexes.aspx

thanks for the question....

and for anyone else asking the question "why would you?":

🙂

Actually....BOL has an example which works

🙂

EXEC sp_addlinkedserver

@server=N'S1_instance1',

@srvproduct=N'',

@provider=N'SQLNCLI',

@datasrc=N'S1\instance1';

...which has just boosted...

Hi all,

this would be extremely useful for a current project, however I'm a little concerned that there seems to be no official documentation for aliasing linked servers in this way...

Does...

Hi there; I had some more specific requirements for this script (handling different collations, nullable columns and possibility that source table is temporary to name a few).

This was a great...

Ever since discovering a use for APPLY for the first time approximately 2 years ago, I've found I use it almost everywhere these days.

To the extent where I start looking...

Are you able to set-up replication of the 3 tables from server B to server A; the view on A will then be much more efficient and replication is very...

thanks Jeff; tried all the code page settings available to BCP, all to no avail...

we don't need to use the csv dumps on that server itself, they're being sftp'ed away,...

...addendum; the Chinese characters only appear when i view the csv files on the SQL Server machine (Windows Server 2008 R2 Enterprise)...

If i copy off to a network share and...

...Thanks; just resolved my issue too, appended a "...-C RAW" statement to the bcp command syntax;

SET @bcpCommand = 'bcp "EXEC <SP> ''' + @batchID + ''', 1" queryout "' +...

function of the week!

thanks

Well, i didn't work out how to stop the full table scan when performing updates across linked-servers, but there is a better way of achieving the required result (as always!).

rather...