Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 31, 2011 06:13 AM by Chen Yu - MSFT
Aug 25, 2011 01:41 PM|LINK
This might seem like a trivial question, but here goes...
I don't do anything strange when I develop my Sql DBs. I just create some tables, populate them with data, and write some standard Sql queries and put these as stored procedures.
The way I see it, this functionality should not yield a lot of code. So how comes Sql Server Express and Management Studio takes up hundreds of megabytes (and Sql Server several gigabytes)? I reckon that at least Magaement Studio should be, say, 3.5 MB in size...
(Note that I haven't downloaded the latest versions, but this was the case a year ago anyway.)
Aug 31, 2011 06:13 AM|LINK
SQL Server has many components and management tools. For example, SQL Server 2008 R2, it has SQL Server Database Engine, Analysis Services, Reporting Services and Integration Services and so on. When you install an instance, you will choose which component
you will install and some of them you need to install by default. So, it becomes hundreds of megabytes or sometimes several gigabytes.