When you create a stage table using CreateStagingClusteredIndex and try to execute the IndexStaging from the script, you get an error for identical index exists.
Msg 1779, Level 16, State ...
Id #10349 | Release:
| Updated: Sep 23 at 10:08 PM by MrPerson | Created: Sep 23 at 9:09 PM by MrPerson
Recently, I migrated a database with a partition table to SQL Server 2014 CTP1 and I noticed that generating the script for a staging table adds TEXTIMAGE_ON even if there are no columns on the tab...
Id #10289 | Release:
| Updated: Aug 21 at 6:16 AM by jsterrett | Created: Aug 21 at 6:16 AM by jsterrett
There is an apparent bug in the way certain computed columns are recreated in the intermediate tables.
In my example below, PartitionManagement has added parentheses around the zero value paramete...
Id #10287 | Release:
| Updated: Aug 20 at 12:23 PM by philiplewis | Created: Aug 20 at 12:23 PM by philiplewis
A new bug was introduced in ManagePartition.exe version 3.0.
The bug is located in the Run() method exceptionn handler at line number 235
catch (Exception e)
Id #9870 | Release:
| Updated: Mar 20 at 1:10 AM by MikeHoney | Created: Jan 24 at 10:12 AM by smurru