Posted by: Denny Cherry
Cache, SQL Server
One of the really cool features of the new SEQUENCES which were introduced in SQL Server 2012 is that you can specify the size of the cache used for each sequence. However Microsoft is recommending that when creating sequences you should always specify the cache size of the sequence. This is because Microsoft has stated that they can and may change the default cache size at their whim between builds of SQL Server 2012 and in the future.
Because of this you should always specify the size of the cache so that you get consistent results from deployment to deployment, especially if you work for a software distributor (ISV, Consulting company, etc.).