none
limitations of sql express edition

Answers

  • SQL Server 2005 Express certainly comes with BCP and SQL Command.
    http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx  (It also comes with SQL Server 2008 Express, in case you plan to move from 2005 to 2008.)

    Also, if you are not familiar with this, the SQL Express Advanced Services include graphical tools to help you manage and program for SQL Server Express.

    Finally, although SQL Server Express does not come with SSIS, you can download the earlier version, named DTS, for use with your Express installation.  The 2005 downloads can be found here.
    http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    RLF

    • Marked as answer by DhruvSingh Friday, January 08, 2010 4:49 AM
    Thursday, January 07, 2010 5:07 PM
  • Yes , certainly you have BCP with SQL express .

    Most of the limitations of SQL Server Express edition will not affect the small/medium scale applications.
    Limitations of SQL Server Express Edition
    1. Number of CPUs supported
    SQL Server Express uses only one CPU at a time. It can be installed on a server with multiple CPUs, but it will use only one CPU at a time.
    2. Maximum memory used
    SQL Server Express uses a maximum of 1 GB memory for it's data buffer. So, if your server has severaql GB memeory, SQL Server Express cannot take advantage of it.
    3. Database size limit
    Maximum database size is limited to 4 GB (log file size is not counted)
    4. Profiler in SQL Server Express
    Profiler tool is not included with SQL Server Express editions.
    5. Job Scheduler
    Job Scheduling service is not available with SQL Server Express.
    6. Import/Export
    Data import and export feature is not available with SQL Server Express.( But can be downloaded as Russell has mentioned)


    Thanks, Leks
    • Marked as answer by DhruvSingh Friday, January 08, 2010 4:49 AM
    Thursday, January 07, 2010 8:32 PM

All replies

  • Hi DhruvSingh Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
    Thursday, January 07, 2010 1:59 PM
  • SQL Server 2005 Express certainly comes with BCP and SQL Command.
    http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx  (It also comes with SQL Server 2008 Express, in case you plan to move from 2005 to 2008.)

    Also, if you are not familiar with this, the SQL Express Advanced Services include graphical tools to help you manage and program for SQL Server Express.

    Finally, although SQL Server Express does not come with SSIS, you can download the earlier version, named DTS, for use with your Express installation.  The 2005 downloads can be found here.
    http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    RLF

    • Marked as answer by DhruvSingh Friday, January 08, 2010 4:49 AM
    Thursday, January 07, 2010 5:07 PM
  • Yes , certainly you have BCP with SQL express .

    Most of the limitations of SQL Server Express edition will not affect the small/medium scale applications.
    Limitations of SQL Server Express Edition
    1. Number of CPUs supported
    SQL Server Express uses only one CPU at a time. It can be installed on a server with multiple CPUs, but it will use only one CPU at a time.
    2. Maximum memory used
    SQL Server Express uses a maximum of 1 GB memory for it's data buffer. So, if your server has severaql GB memeory, SQL Server Express cannot take advantage of it.
    3. Database size limit
    Maximum database size is limited to 4 GB (log file size is not counted)
    4. Profiler in SQL Server Express
    Profiler tool is not included with SQL Server Express editions.
    5. Job Scheduler
    Job Scheduling service is not available with SQL Server Express.
    6. Import/Export
    Data import and export feature is not available with SQL Server Express.( But can be downloaded as Russell has mentioned)


    Thanks, Leks
    • Marked as answer by DhruvSingh Friday, January 08, 2010 4:49 AM
    Thursday, January 07, 2010 8:32 PM
  • 7. Reporting services are also not fully implemented in SQL Server Express.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Thursday, January 07, 2010 8:44 PM
  • Hi Naom,

    Are you asking about the feature pack for 2008 , if yes have a look here http://www.microsoft.com/downloads/details.aspx?familyid=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en .


    Thanks, Leks
    Friday, January 08, 2010 8:17 AM
  • I've checked this link and it doesn't look like it includes anything related to SSIS or SSRS - two main features I'm missing in SQL Server Express (it does have SSRS, but very limited).
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Sunday, January 10, 2010 2:11 AM
  • 1. Number of CPUs supported
    SQL Server Express uses only one CPU at a time. It can be installed on a server with multiple CPUs, but it will use only one CPU at a time.


    "Only one CPU at a time"! you meant the database can't use as  server-client system?
    Tuesday, September 21, 2010 12:26 PM
  • Certainly you can use it for a client/server system.  The "one CPU" is a limit to how many resources SQL Express will use.  It is also limited to the amount of memory it can use and the size of the database files.

    Having said this, SQL Express contains the full capability to handle many simultaneous activities through its time slicing.   In this post, Adam Machanic gives a good explantion under the topic: Background: Threads, Threading, and Other Sewing Analogies

    http://sqlblog.com/blogs/adam_machanic/archive/2010/05/24/sql-university-parallelism-week-introduction.aspx

    Once upon a time running a single-CPU SQL Server was quite common, even for "big" (for that time) databases.  And you will still find a lot of single-CPU SQL Servers in common use, though not for today's BIG databases.

    RLF

    Tuesday, September 21, 2010 1:44 PM