I think it would be useful to tell us for which version of SQL Server this question is corresponding. I am not sure that with the new query optimizer ...

I would suggest you to have a look at these links :

http://blogs.msdn.com/b/jneave/archive/2011/04/15/tcp-provider-error-semaphore-timeout-from-an-ssis-package.aspx

http://blogs.msdn.com/b/oldnewthing/archive/2014/07/17/10543082.aspx

(Remark :according this last link , it seems that this problem was usual on Windows Server 2003 ,...

Voted even if I faced this problem only one time since SQL Server 2008.

For the support of SQL Server 2008 , I would suggest you to have a look at

http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx

Have a nice day

for the SQLCMD for SQL Server 2008 ( version 10 ) , you could try

or try this link :

http://www.microsoft.com/en-us/download/details.aspx?id=27596

Be careful , I am thinking that the support is ended for...

Hello rheeler2,

To connect to your SQL Server the first time after its install , it is better :

- to connect to the computer on which the SQL Server , you...

In the link provided with the explanation for the "good reply" of the question , I have seen a little add-in from Rick Byham ( who is correcting most of...

Please , is it possible that someone explains me this sentence found in http://msdn.microsoft.com/en-us/library/ms188029.aspx ?

"When a sparse column is included in the select list, the sparse column property does not...

In http://msdn.microsoft.com/en-us/library/ms187403.aspx , I found

"The SET ANSI_PADDING setting does not affect the nchar, nvarchar, ntext, text, image, and large value. They always display the SET ANSI_PADDING ON behavior. This...

Please , could you provide more information about your problem ?

- 1 How do you know that the columns are not the same order ? Are you relying on...

Hello Tom

Thanks for your explanation. I have searched in the SQL Server 2014 BOL , I have found nothing about it but I have noticed that , very often ,...

Please , could you explain me this excerpt ?

"The exception is tabular models that have been deployed in DirectQuery mode, which do not retrieve data from an Analysis Services data...

Hello IgorMy,

My wife has come back from Canada this morning ( 9:00 AM Paris time ) with a gift which could close that discussion as , at a first glance...

Hello John Mitchell ,

Thanks for your reply which is confirming what I was thinking especially about LOB and maybe FILESTREAM ( and what about the FileTables ? )

Maybe the creator...

I would suggest to read

http://msdn.microsoft.com/en-us/library/bb964719.aspx

you will discover

"•Whether the database is compressed.

If the database is compressed, compressing backups might not reduce their size by much, if at all."

Maybe I...