Sometimes you CAN upsize a column in-place
Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.
Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.
We had a case where we increased a varchar column's size, ONLINE, but it caused significant downstream effects. See why.
There are some limitations with STRING_SPLIT that could be overcome, but the cleanest solution might be to add a new function altogether.
SQL Server 2016 SP2 Cumulative Update #14 is available, with 18 enhancements. The build number is 13.0.5830.85.
My daughter surprised me with a question about work last week, and I answered her by invoking Taylor Swift.
SQL Server 2019 Cumulative Update #6 is available, with 51 enhancements. The build number is 15.0.4053.23.
Find out about the replacement I wrote for the undocumented, unsupported, and ill-advised system procedure, sp_MSforeachdb.
A quick update on some maintenance I performed on the site over the weekend.