We are running SQL Server 2012 Standard Edition.
Need to change the name of a column in a table with +100M rows.
This table is heavily used at all times.
I can't say at this moment if the column in question is part of an index (should I expect different behavior in case it is?)
What is the performance impact I should expect when running:
EXEC sp_rename 'myTable.oldColumnName', 'newColumnName','COLUMN'
EDIT: This column was created for future needs, we know is it not used in any part of the system. It has only null values. I'm offline right now, not sure if it is included in an index (by mistake)
EDIT 2: Most transactions on this table have with(nolock) hint. Do you think running sp_rename at isolation lever read uncommitted is the way to go?