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
Last activity: May 21, 2025, 04:03 PM