CODEWITHSUNDEEP
windowssql-server-express
CJ7
CJ7

Reputation: 23295

Why ever not use SQL Server Express for Windows based application?

Considering that SQL Server Express is free, why would you ever use any other database for a Windows based multi-user database-driven application?

Upvotes: 0

Views: 2096

Answers (1)

Shaun
Shaun

Reputation: 2476

Because (not sure if all of these are still true, but they were at one time):

  • Limited to 1GB of memory
  • Database size limited to 4GB (10GB in newer versions)
  • It can only use one CPU
  • No importing or exporting of data
  • No job scheduler

There are a lot of applications for which the above factors make SQL Server Express impractical.

Upvotes: 8

Related Questions