zblog-2.2 version of ASP program best Choose SQL Swever2008 version of the database

I have always been a loyal user of the Zblog program, whether it is to do a small blog, or to help friends build enterprise Web site, are using this system, because familiar with, do not want to study other procedures, because I am a small white technology, other systems also feel difficult, So over the years have been using the ASP program to build some of the data is not a very large site, but also tried to use PHP, but found that the ability to resist the pressure is very limited, it may be my system and database building optimization is not good enough?
Xiao Bo information: http://www.simayi.net/and it learning to share topics, mainly on education and learning content.
Today to share with you about the use of the ASP2.2 system to carry the database, the personal recommendations of the use of SQL server2008, one might say, the database is not the newer the more powerful, the more useful? In fact, the new version of the database also has some more troublesome problems exist.

Recently, I used SQL server2012 to try to build a website, but encountered a very annoying problem: that is, every time you restart the server or restart the SQL server2012 service, all the "self-increment attribute" column will have a numeric jump problem, such as the ID in your database table, If you set the self-increment identity specification = 1, identify seed = 1, then it will increase 1000, for example, before restarting the server, your ID is 105, then restart the new data row ID will become 1106, a full increase of 1000, this troublesome problem I queried the network of many solutions, But it did not solve the problem.
and in SQL server2005 or SQL server2008 These two very mature version of the time, there will be no such trouble, I believe that for many webmasters, this problem is also very concerned about, special and everyone to share!

zblog-2.2 version of ASP program best Choose SQL Swever2008 version of the database