SQL Server 2012 generating non-sequential identity values?
In my coding I never assume the value of a new identity field, which sometimes makes for extra work and could slow down high-volume code, but evidently some applications do assume. If yours is one of them, beware.
MDS: Copying models and data to another server – SQLServerCentral. This SQLServerCentral article caught my eye because it explains a process I will soon be carrying out, moving MDS data from development to production. It looks as though the advice given could save a substantial amount of trial-and-error. Thanks to the … Continue reading →
Cumulative Update #4 for SQL Server 2012 – Microsoft SQL Server Release Services – Site Home – MSDN Blogs.