Thanks. I don't think it has unicode but I'm not sure what exactly that is and I haven't been able to find any good samples by googling.

Is this it?

It took 38 seconds to run it this time. 30896798.

Even just doing a count(*) on table is different. Faster one takes 1 second and slower takes 16 seconds.

it creates a new table every week when they import the file. The ceo wanted the server to not be on a network so the text file is placed on...

Faster:

configuration_idnamevalueminimummaximumvalue_in_usedescriptionis_dynamicis_advanced
101recovery interval (min)00327670Maximum recovery interval in minutes11
102allow updates0010Allow updates to system tables10
103user connections00327670Number of user connections allowed01
106locks0500021474836470Number of locks for all users01
107open objects0021474836470Number of open database objects01
109fill...

How do I show the output for the SELECT * FROM sys.configurations query? Can I attach an excel spreadsheet?

Faster - Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64)   Jun...

It is KB.

No the files are on the C drive only for both servers.

Sure, I'm just not sure what all you need. The text file size is 2995902. and it is around 30 columns. Both servers are running the exact same bulk insert...

They have office installed because this place uses the server like a big desktop. The faster one has a Local Disk C drive and a DATA D drive. The slower...

File is in a folder on C drive for both. How do I configure the drives and compare performane? Sorry, I'm not a dba at all and got handed this...

• This reply was modified 3 years, 10 months ago by  smattiko83.

Thanks again for all your help. Did the sample look ok?

It seemed to work if I change the rowterminator to below. Does the sample look right?

,ROWTERMINATOR = '0x0a'

• This reply was modified 4 years, 1 month ago by  smattiko83.

It still didn't work without the powershell. Is the attached what I need to do for the powershell? It doesn't seem to do anything.

Thanks. For the powershell part, do I need to modify it for my PC or what do I need to do?