Can you elaborate a bit?

There is a windows client domainx\userA on client Z on domainx

That has acces to server 1,2,3,4,5,6,7

Question:

If i move the user from client Z to client W,...

Happy New Year 2021

Had to lookup up what you meant with "magic tables". Are those the inserted / deleted tables you can reference from triggers or the output clause?

What is magic table in...

For TLS 1.2 you'll need version 11.0.6216.27 https://support.microsoft.com/en-us/help/3135244/kb3135244-tls-1-2-support-for-microsoft-sql-server

Might als wel update to SP4 + CU + security fix https://sqlserverbuilds.blogspot.com/#sql2014x.

Can't verify it because our servers are 2017+

What is the patchversion of SQL Server 2014 ? It could be that TLS 1.2 is now required

Can we upgrade straight to CU15 for CU12: yes . CU's contains the patches since SP2

SSMS: check releasenotes https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15

Have it as a text parameter instead of datetime? Use a second internal parameter to convert the text to datetime?

Thanks for the feedback

Is max memory for the sql server instance set to lower than  839GB, so other applications like the operating system can run?

Is SSAS installed on the server? There was a...

Happy thanksgiving. Hopefully next year in different circumstances

You might want to try out table/index pagecompression to reduce the size

There are no more servicepacks since SQL 2017 as part of the cloudfirst strategy. Currently at update 22. https://sqlserverbuilds.blogspot.com/

*edit* You might consider SQL Server 2019 is your project is still...

• This reply was modified 4 years, 11 months ago by Jo Pattyn.

In Belgium were are back in lockdown mode. Most shops have to close.

For the spookiest year , I nominate the year the asteroid hit Earth and wiped out the dinosaurs

7) Why are you still on 2017 RTM

Sounds right. Largely depends on the goal of insert/update/delete

don't use big transaction -> big transactions lead to longer locking times, greater chances to fill up disk space

perform insert?delete and update...