Currently our company has an ASP application using an SQL 2005 Workgroup edition database. We are in need of a new server and are debating about whether 2012 SQL Express(since it is free) will work with our ASP code. Our database is currently 6GB in size and I think the limit on Express is 10GB. My bigger concern is speed of queries and data retreival using Express. Anyone have any experience with downsizing to Express?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Downsizing to SQL 2012 Express
- Thread starter clmp
- Start date
SQL express is limited to a single CPU, which might cause you some problems. On the other hand, there have been improvements to the database engine which may actually improve performance. All I can really say is... Try and see.
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
- Status
Similar threads
- Locked
- Question
