Viewing 15 posts - 1 through 15 (of 49 total)
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.
March 10, 2021 at 8:21 pm
It took 38 seconds to run it this time. 30896798.
November 24, 2020 at 8:18 pm
Even just doing a count(*) on table is different. Faster one takes 1 second and slower takes 16 seconds.
November 24, 2020 at 6:21 pm
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...
November 24, 2020 at 6:04 pm
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...
November 24, 2020 at 6:00 pm
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...
November 24, 2020 at 4:25 pm
It is KB.
No the files are on the C drive only for both servers.
November 24, 2020 at 3:54 pm
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...
November 24, 2020 at 3:35 pm
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...
November 24, 2020 at 3:32 pm
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...
November 24, 2020 at 2:19 pm
It seemed to work if I change the rowterminator to below. Does the sample look right?
,ROWTERMINATOR = '0x0a'
July 30, 2020 at 3:45 pm
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.
July 30, 2020 at 3:16 pm
Thanks. For the powershell part, do I need to modify it for my PC or what do I need to do?
July 30, 2020 at 1:23 pm
Viewing 15 posts - 1 through 15 (of 49 total)