Dear Mr. Celko,
Please limit your criticism to that of a constructive nature. Remember us...

EXEC sys.sp_MSforeachdb
   @command1 = N'USE [?];IF ''?'' NOT IN(''msdb'', ''master'', ''tempdb'', ''model'') AND NOT EXISTS(SELECT principal_id
FROM sys.database_principals dp
JOIN sys.database_role_members drm ON dp.principal_id=drm.role_principal_id
WHERE dp.name =...

SELECT [Line of Business],

July 23, 2018 at 4:46 pm

#1998703

Please repost your sample data as Table DDL and DML. A picture may be worth a thousand words but it's useless for posting to a SQL forum.

The issue here is the latency with web service requests processed RBAR. If you could upload the data to Melissa so they could import and enhance the data all on...

Drop and recreate the index.

What OS are you installing on?

Right click the linked server and select properties. Set RPC, RPC Out and Enable Promotion of...

Is DTC enabled on both servers?

Based on that I would change my answer to it depends on it's rate of

When Page Compression Occurs

When a new table is created that has page compression, no compression occurs. However, the metadata for the...

Post the code

Yes, and it doesn't mater how it's inserted.

Does the account SQL Agent runs under have permissions to the package path?

In the flat file connection manager make sure the column is defined with a length long enough for the longest value.