Monthly Archives: November 2012

How BIG is too BIG for a BIGINT IDENTITY?

After writing a recent blog post on Are you wasting half the capacity of IDENTITY, I started thinking about how much is too big for an BIGINT IDENTITY. If you don’t know about, you can get Are you wasting half the capacity

Posted in SQL 2008, SQL 2012 Tagged with: , , ,

Are you wasting half the capacity of IDENTITY?

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how

Posted in Database Health Tagged with: , , , , , , , ,

Muda – or the 7 Deadly Wastes

In the manufacturing world it is referred to the 7 wastes, or the Japanese term Muda.  How does this apply to software development. THE 7 WASTES OR MUDA ARE: Transportation Inventory Motion Waiting Over-Processing Over-Production Defects These all apply to

Posted in LEAN Tagged with: , ,

Database Health Version 3.1 So Soon After Beta 3

Today I release Beta 3.1 of the Database Health Reports. Immediately after the release of Beta 3, there were 3 bugs reported that were very quick to fix.  I was able to get these fixed, along with one other bug

Posted in Database Health Tagged with: ,

Beta 3 is Now Available.

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing

Posted in Database Health Tagged with: , , , , , , ,

Beta 3 of the Database Health Reports will be launched tomorrow.

Finally after a month and a half of preparation on Beta 3 of the Database Health Reports, it will be released tomorrow. The biggest feature in Beta 3 is the historic monitoring.  This process installs a small database to track

Posted in Database Health Tagged with:

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: