Sample Header Ad - 728x90

Changing column type from Decimal (16,2) to Decimal (32,2) on table size 500million rows

0 votes
1 answer
105 views
Hi folks I have a database part of an AG,I need to change the column type from Decimal (16,2) to Decimal (32,2). Does anyone know the best way I could do that above without bloating the log? My thinking is: 1 - take the database out the AG 2 - create a new table with the requested datatype (32,2) 3 - insert the data into the new table Any suggestion ?
Asked by Daniel (137 rep)
May 20, 2025, 10:34 AM
Last activity: May 21, 2025, 04:03 PM