More from our Blog
Use caution when mapping Oracle data types for procedures and function parameters in SSMA
Mapping Oracle data types to SQL Server data types is often a problem during Oracle to Microsoft SQL Server database code conversions. A tried and trusted solution is to use an SQL Server database code conversion. Another reliable solution is to use SQL Server Migration Assistant. These solutions enable you to automate Oracle database conversions […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
Oracle to SQL Server migration with SSMA: Converting materialized view with float type
A materialized view is an important property of Oracle. SQL Server recreates the same behavior as this materialized view in several ways. Unfortunately, SSMA may have issues with converting this object to SQL Server. It flags certain conditions as an error. In this blog post, we will overview the error O2SS0522. It goes about cases in […]
Andrey Khudyakov
Improving SQL Server statistics update: How do you make it 1000 times faster than traditional approaches?
One of our clients contacted ABCloudz to request help with their SQL Server app’s performance issues. They upgraded from SQL Server 2008 R2 to SQL Server 2019 and began experiencing problems shortly after. We analyzed their database system and discovered a complex issue with updating SQL Server statistics. These stats are used by the Query […]
Roman Muzyka, Andrey Khudyakov
Ready to start the conversation?
ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!
