Monday, April 09, 2012

Aaron Bertrand : Two bugs you should be aware of

Questioning using SQL 2012 as a production environment?  There are a few critical issues with the current platform that may make you want to think about when SP1 is coming out….

This one is critical for those that think identity should be an auto-incrementing sequential key.

Just to add to your list. There is one more critical bug wherein if you define identity column on a table and insert some values. Thereafter restart SQL server and insert further more values and do a restart again and then when u insert in that table there are large gaps in the identity values.

Aaron Bertrand : Two bugs you should be aware of

No comments: