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_id	name	value	minimum	maximum	value_in_use	description	is_dynamic	is_advanced
101	recovery interval (min)	0	0	32767	0	Maximum recovery interval in minutes	1	1
102	allow updates	0	0	1	0	Allow updates to system tables	1	0
103	user connections	0	0	32767	0	Number of user connections allowed	0	1
106	locks	0	5000	2147483647	0	Number of locks for all users	0	1
107	open objects	0	0	2147483647	0	Number of open database objects	0	1
109	fill...

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?