PASS Pro Now Available

Welcome to the next evolution of PASS. Unlock exclusive training, discounts, and networking opportunities designed to accelerate your data career. Learn More >

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.

We've moved!

Looking for the latest blog posts? We've recently moved the PASS Blog to its new home at You can still view older blog posts here but please update your bookmarks so you can continue getting the latest posts from the PASS Blog.

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