I think a table for each

• This reply was modified 9 months ago by  smattiko83.

Would I need to do a LEAD to compare the next_visit to the admit and discharge dates? The 10/24/22 one is during the next admit and now they would like...

Thank you so much. I've never seen/used OUTER APPLY before.

Thank you.

How do I execute what is printed?

I am using it to change the column names. I've tried alter view but it does not work.

• This reply was modified 1 year, 4 months ago by  smattiko83.

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...