1

I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is the Express Edition 2017.

  1. Will the express edition support procedures, triggers, dynamic sql, PIVOT, sequences, dynamic management views and functions?

  2. Will it be upgradable to adding ssis, ssrs and ssas in future (I read documentation on Microsoft community blogs, but couldn't find an answer specific to this edition), maybe I will need them in future.

6

You should simply download and use SQL Server 2017 developer edition. Dev edition is same as enterprise edition so regarding feature you would not have any limitation and free to use for testing and learning. Do not use it in production

| improve this answer | |
  • Thanks for the quick reply.I did read about it,the main reason why I go after light weght edition is that my PC has very less RAM and HDD space. – aravind nk May 29 at 17:41
  • Can you let me know how much space and RAM you have. Plus if you really want to learn SQL Server I believe at least 4 GB RAM plus fair amount of disk space would help you. – Shanky May 29 at 17:47
  • 4GB RAM,240 GB SSD – aravind nk May 29 at 17:48
  • Sufficient for you to use DEV edition. – Shanky May 29 at 17:49
  • Agree with @Shanky. It may not run quickly, but it will run. (You may have memory issues, depending on what else is running on your laptop.) – Philip Kelley May 29 at 18:18
1

The smallest SQL Server you can install for development purposes is SQL Server Express LocalDb

Microsoft SQL Server Express LocalDB is a feature of SQL Server Express targeted to developers. It is available on SQL Server Express with Advanced Services.

LocalDB installation copies a minimal set of files necessary to start the SQL Server Database Engine. Once LocalDB is installed, you can initiate a connection using a special connection string. When connecting, the necessary SQL Server infrastructure is automatically created and started, enabling the application to use the database without complex configuration tasks. Developer Tools can provide developers with a SQL Server Database Engine that lets them write and test Transact-SQL code without having to manage a full server instance of SQL Server.

Both LocalDB and the "regular" Express Edition have all the programmability features of Enterprise/Developer edition. The regular Express Edition installs a Windows service and is running all the time unless you stop/start the service, and is about 500MB installed. LocalDb runs only when your app is running, and is about 250MB on disk.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.