Assume that you use Microsoft SQL Server 2012 or SQL Server 2014. When you try to add columns with variable data type online in a temp table, and the columns have a default constraint, a memory leak occurs in USERSTORE_SCHEMAMGR. Additionally, the memory leak may cause the resource monitor to spin, and this could lead to CPU spikes.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3032476 - Last Review: Jun 22, 2015 - Revision: 1