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!
More from our Blog
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 which the Oracle materialized view includes FLOAT columns, subqueries, GROUP BY or WHERE clauses, MINUS, INTERSECT, UNION, etc. By default, SQL Server Migration Assistant (SSMA) converts Oracle […]
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 Optimizer to create an execution plan for each query. The problem was that the time to update statistics was taking much longer than the planned […]
