Always set the SEQUENCE cache size
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 […]