with the new 'jump identity value' feature in SQL 2012,
one SQL MVP says
"If you need contiguous numbers, you should not use neither IDENTITY nor sequences"
there is a Trace fix.. but in one of the user comments i read [This (trace fix) is working for standalone server but not cluster servers.]
1)if you do desire contiguous numbers, what options do you have other than SQL Identity or sequences?
2)from what i understand, the trace 272 suppresses the cache feature in sql 2012 for identity column: if high availability feature is turned on or used in 2012, if there is a failover, will the trace be effective in that scenario,?