SQL Server Express 2008
SQL Server Express 2008
About:
Microsoft SQL Server Express, a freely-downloadable and -distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications. Unlike its predecessor, MSDE, it lacks a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users."[1] It does, however, have a number of technical restrictions which make it undesirable for large-scale deployments, including:- maximum database size of 4 GB per database (compared to 2 GB in the former MSDE). The 4 GB limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.
- hardware-utilization limits:
- Single physical CPU, multiple cores[2]
- 1 GB of RAM (runs on any size RAM system, but uses only 1 GB)
- absence of the SQL Server Agent service
wikipedia.com
My Uses:
I have been using this as a backend to a helpdesk program.
Mangement program:
MS SQL Server managment studio
Notes:
A problem i had recently was that i was trying to add an active directory domain group to the logins on the server. In 2005 this was possible but this feature has been removed for 2008. You have to add a direct user into the login section, groups are not allowed.
