SQL Server Express is one of the most valuable products of Microsoft. Very often, I face many questions with regard to SQL Server Express. Today, we will be covering some of the most commonly asked questions.
Q: What is the cost of SQL Server Express?
A: It is a FREE product from Microsoft.
Q: Why should I use SQL Server Express when I have full version available?
A: Usually, I install only the license version product on my system. When I do not have to use all the features of SQL Server, I install the express version.
Q: What is the maximum size per database for SQL Server Express?
A: It supports a maximum size of 4 GB per database, which excludes all the log files. 4 GB is not a very large size; however, if the database is properly designed and the tables are properly arranged in a separate database, this limitation can be resolved to a certain extent.
Q: Can MySQL be compared with SQL Server Express as both of them are free products?
A: Yes. Both are free and have their own space. However, thus far, I have never faced a situation wherein the task that can be accomplished by using MySQL is not accomplished by SS Express.
Q: Does SQL Server have sufficient help available online?
A: Yes. There are so many online help resources available for Express version that users will find strongest community for any FREE product.
Reference: Pinal Dave (http://blog.sqlauthority.com)