Click here to Skip to main content
15,749,281 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
1)Is SQL SERVER EXPRESS EDITION 2012 free? because some said that it's draw back is it required cost. or its depend on vendor to where you download SQL SERVER.

2)Is it the case that some tools in it are chargeable like DTA?

3) which version on ms sql server are paid?

1 solution

1. Yes, SQL Server 2012 Express is a free edition with few limitations.
Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

Download link-[^]

2. DTA is not supported in the express edition.
Here is the deatiled list of features supported by different editions of SQL Server 2012[^]

3. All other versions except Express are paid.

Hope, it helps :)
Share this answer
Member 11922776 10-Sep-15 2:18am    
I found some limitations as follows, Is there some which I missed compare to other sql server edition?

1)Buffer pool extension to SSD
2)Backup encryption support
3)Disaster recovery to Microsoft Azure

It support 10GB of database then what will happend when data exceed it. then is it haddle by file system?

My database is big enough, then what would you suggest me from Sql server express edition and MySql(as its all n complete version is free).

thanks for answer.
Member 11922776 10-Sep-15 2:32am    
thanks for suggestion. may you give knowledge about how database is handle when exceed than 10GB in sql server express, please.
Suvendu Shekhar Giri 10-Sep-15 2:47am    
You'll get error saying something like
"Could not allocate space for object 'dbo.[table]' in database '[database]' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup."
You can still execute SELECT, DELETE & UPDATE statements.

You can reduce the database size by deleting the log file.
Member 11922776 10-Sep-15 3:27am    
thank you..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900