Are you using four part naming in the view? If you are then all the rows for the remote table will be returned before filters are applied.
You might be...

I think BCP needs a format file for this.

I  tend to use Powershell for this type of processing with the Out-DataTable function:

https://gallery.technet.microsoft.com/scriptcenter/4208a159-a52e-4b99-83d4-8048468d29dd

I then ...

I have recently been moving a lot of DBs to SQL2017 and doing an intial check with the Data Migration Assistant.
It produces the following warning with the old join...

Here is the last of a series of article by Kathi Kellenberger which quickly explains the basics of SSRS.
Start by reading  Part1 and Part4.

https://www.red-gate.com/simple-talk/sql/reporting-services/sql-server-reporting-services-basics-deploying-reports/

SELECT '07-11-18', CONVERT(date, '07-11-18', 5)

We are currently in the process of removing our SQL2008 instances before they go out of extended support next July.

Most of the DBs will be moved to SQL2017...

I am not quite sure what you are doing but the following may help.

-- *** Test Data ***
CREATE TABLE #t
(
    quantity_text varchar(255) NOT NULL
);
INSERT...

I would start with something simple like:

SELECT DISTINCT
    P.state_desc COLLATE DATABASE_DEFAULT + ' '
    + P.[permission_name] COLLATE DATABASE_DEFAULT + ' TO '
    + R.[name] COLLATE DATABASE_DEFAULT + ';'

Just remember that you might not be the only person taking backups.
eg Your systems team might be taking VSS backups which could be differential as well as full.
You...

Hi Deepak,

Thank you for your timely article.

I have no experience of Azure but we have been asked to look at the possibility of moving some of...


DECLARE @t decimal(10,2) = 3.25;
SELECT CONVERT(char(8), DATEADD(second, @t%1 * 60, DATEADD(minute, @t, 0)), 114);


Try specifying the date in ISO format:
AND SLD.docenimerosisdate >='20180202'

https://blogs.sap.com/2017/11/28/upgrade-to-and-installation-of-sql-server-guides-moved-to-sap-help-portal/