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.)
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.
Thanks.
Please mark the replies as answers if they help or unmark if not.
Feedback to us
pettrer
Participant
970 Points
469 Posts
Filesize of Sql Server Express/Management Studio
Aug 25, 2011 01:41 PM|LINK
Hi all,
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.)
Just curious!
/Pettrer
Chen Yu - MS...
All-Star
21600 Points
2493 Posts
Microsoft
Re: Filesize of Sql Server Express/Management Studio
Aug 31, 2011 06:13 AM|LINK
Hi,
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.
Thanks.
Feedback to us
Develop and promote your apps in Windows Store