The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Steve Stedman's Articles

Are you Wasting Half the Capacity of IDENTITY?

Over time, I have worked on many databases that have used an INTEGER identity as a primary key or clustered index value. Most of the time there haven’t been any issues, but occasionally, I come across a problem table where the IDENTITY value ran out and inserts statements, then failed. This has typically been in a case of a logging table of some type.

Read the rest of entry » Comments

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids