In my new job position I have to administer a SQL Server 2019 which is constantly hit by Microsoft Access applications.
Sometimes queries are slow so I read one of your post where you suggest what to do to improve performances: https://www.fmsinc.com/microsoftaccess/Performance.html
The problem is that I also read this post https://www.brentozar.com/sql-server-access-data-types/ where I discovered that there are Data Types that exists in Microsoft Access but they don't exists in SQL Server:
So my question is: does Microsoft Access makes an implicit conversion every time it translate a "Short text" to a "bigint"?
(I used "Short text" to a "bigint", you can pickup what ever Data Type you want from the table above.)
Please sign in to leave a comment.