Dan Waters
dwaters at usinternet.com
Sun Aug 8 10:34:19 CDT 2004
Good Morning Gustav! You said, "a new set of management objects,". Do you know if these objects replace Enterprise Manager? Thanks! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Sunday, August 08, 2004 9:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SQL Server 2005 Express: No query governor Hi all Browsing Mike Gunderloy's newsletter I noticed this which I haven't seen mentioned anywhere else and makes a big difference between the earlier MSDE and the new SQL Server 2005 Express: --- One of the nicest things about SQL Server Express is what's been left out: the query governor from MSDE, which added arbitrary slowdowns when you had more than five active connections, is gone. This makes SQL Server Express a much more useful tool. In particular, many database-backed Web sites should be able to get by with this version of SQL Server and not pay a dime in licensing fees. The maximum size of databases is also doubled from MSDE, to 4GB. Maximum memory, however, is halved to 1 GB. Still, the majority of small and medium sites won't have a problem with this. You also get very nearly all of the features of the full, paid versions of SQL Server 2005. The major missing features include Reporting Services, Notification Services, Analysis Services, Full text search, DTS, and OLAP features. If you want to use these higher-end features, you need to move up to a non-free version of the product. What you DO get is pretty impressive. In addition to the features of SQL Server 2000, the 2005 revisions add thorough XML support, support for using the .NET Common Language Runtime integrated with T-SQL, a new set of management objects, and the ability to act as a client in both replication and messaging scenarios. .. --- /gustav -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com