DefaultBufferMaxRows = 2000 -- change to 50000

DefaultBufferSize = 1048576 -- change to 10485760 ( x 10 basically)

tablock = set to true so it can use minimal logging

connection string - set...

are you sure that tbl_name  is really a table and not a view?

that SQL so simple would give that error if it was from a view with invalid data on...

well.. it depends..

Today I've loaded 16 Million records in 34 mins - 650 bytes per row - table already had 50 Million rows

and this is loading onto a staging table...

Others will comment - most likely with better answers than mine.

regarding the 1 min interval - that is the default on 2016+ but it can be set in seconds so...

to "develop" the SSIS package you need 32bit versions of the clients as Visual Studio is a 32 bit application.

you can have both 32 and 64 bit versions of the...

your only solution is to create it as a table is you need to create an index to it.

• To create an indexed view you are required to use SCHEMABINDING...

Nothing wrong with COBOL!!!! and still use it on my shop.

As for fixed width files - in many cases it is better than delimited mainly if data can contain lf/cr...

first - did you install the 32 bit version of the client

second - did you setup a tns name entry for it

third - if you do "tnsping oraclesid" does it...

have you read the manuals? Info is clear there.

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-ver15

well. does not matter if I confirm or not - I still get the emails (reply to posts and news letter) but message won't go away.

go to the point where...

I really don't understand the amount of people that haven't changed the the Catalog, nor the resistance people give. The actual migration isn't actually that hard, provided you...

One idea, using Powershell, would be something like this.

Firstly set up some test objects:

CREATE TABLE dbo.ServerList (ServerID int IDENTITY PRIMARY KEY,
     ...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

no need for a loop as far as I can see, but a sub select required to ensure we do get the correct date set

UPDATE A
SET ...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.
• This reply was modified 5 years, 8 months ago by frederico_fonseca.

what does the output of this query give you on new server and old server?

select name, is_recursive_triggers_on

from sys.databases

where name = 'mydbname'

replace mydbname with correct name

you also need to consider what the usage of the view is going to be. if majority of access will use a filter which you stated is faster than the...