What are the differences between microsoft sql server-enterprise edition and its standard edition? Why enterprise edition is preferred over standard edition?  

The Enterprise Edition is the big-iron edition of SQL Server. Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

Data on SQL Server Enterprise can be carved up to work in parallel, called scaling out. Another way to provide higher uptime using this version is log shipping, meaning that changes made on one server can automatically be transferred to another server (perhaps located elsewhere) and applied to keep them in periodic sync.

Another feature that this edition provides that's often overlooked is as a back-end to reporting data. When you structure reporting data, it often has a negative impact on performance. With SQL Server Enterprise Edition, you get indexed views, which can really help a skilled developer speed up those reports.

There's yet another benefit to this edition: The samples area is greatly enhanced in this release. For the developer, this sample code can be very useful.

There are a couple of minor issues with this edition. For one, the 64-bit version of this edition doesn't support running Data Transformation Services, although you can run that on another 32-bit system and reference a 64-bit edition. You're also limited to the Itanium 64-bit processor.

Standered edition really moves into the higher-end spectrum. It has more capabilities than its predecessor, and can even be clustered together, up to two nodes. There is no memory limits for this Edition.

In addition, the Standard Edition has a 64-bit version, which uses a flat memory space and a larger addressable CPU space. It has the following primary features:

* Relational Database Management System with development studio integration
* Clustering
* Replication
* Encryption
* Full XML support
* HTML support
* Service Broker
* Analysis Services
* Reporting Services
* Data Mining
* Common Language Runtime integration (you can write stored procedures in any .NET language)
* Integration Services (replaces the Data Transformation Services from 2000).............

Answered by Rupesh at 12:20 PM on June 03, 2008

The Standard Edition of SQL Server 2000 is the version intended for the masses—those running small- to medium-sized systems that don't require the performance, scalability, and availability provided by Enterprise Edition. The Standard Edition runs on any of the Windows 2000 or Windows NT 4.0 Server platforms with scalability limited to up to four processors and 2GB of memory. Standard Edition includes the following features:

Analysis Services
Data Transformation Services
Full Text Search
English Query
Built-in XML support
SQL Profiler and performance analysis tools
Graphical DBA and Developer tools
Replication
Data mining tools

The Standard Edition should meet the needs of most departmental and small- to mid-sized applications. However, if you need more scalability, availability, advanced performance features, or comprehensive analysis features, you will want to implement the Enterprise Edition of SQL Server 2000.

The Enterprise Edition of SQL Server 2000 is the most comprehensive and complete edition available. It provides the most scalability and availability of all editions and is intended for systems that require high performance and availability, such as large volume Web sites, data warehouses, and high throughput online transaction processing (OLTP) systems.

SQL Server 2000 Enterprise Edition supports up to 64GB of memory and up to 32 processors when it is installed on Windows 2000 Datacenter Server. It supports up to 8GB of memory and 8 processors when it is installed on Windows 2000 Advanced Server. To provide these capabilities, SQL Server 2000 Enterprise Edition can be installed only on Server versions of Windows 2000 and Windows NT.

Additionally, SQL Server 2000 Advanced Server provides performance enhancements such as parallel query, indexed views, and enhanced read-ahead scanning.

For deploying SQL Server 2000 in a server environment, either the Standard or the Enterprise Edition of SQL Server is a logical choice.

While all editions of SQL Server 2000 allow the creation of indexed views, only the Developer and Enterprise Editions of SQL Server 2000 will automatically consider using an indexed view in query plans. To force the optimizer to consider indexed views in other SQL Server editions, the NOEXPAND hint must be included in the query. For more information on using indexed views and how they are handled by the query optimizer.

Answered by Anju Singh at 6:06 AM on June 03, 2008

well Baladutt, The Standard Edition of SQL Server 2000 is the version intended for the masses—those running small- to medium-sized systems that don't require the performance, scalability, and availability provided by Enterprise Edition. The Standard Edition runs on any of the Windows 2000 or Windows NT 4.0 Server platforms with scalability limited to up to four processors and 2GB of memory. Standard Edition includes the following features:

Analysis Services

Data Transformation Services

Full Text Search

English Query

Built-in XML support

SQL Profiler and performance analysis tools

Graphical DBA and Developer tools

Replication

Data mining tools

Another feature that this edition provides that's often overlooked is as a back-end to reporting data. When you structure reporting data, it often has a negative impact on performance. With SQL Server Enterprise Edition, you get indexed views, which can really help a skilled developer speed up those reports.

Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. Workgroup Edition can serve as a front-end Web server or for departmental or branch office operations. It includes the core database features of the SQL Server 2005 product line.

* Standard Edition
Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for non-critical e-commerce, data warehousing, and line-of-business solutions. Standard Edition's integrated business intelligence and high-availability features provide organizations with the essential capabilities needed to support their operations.
* Enterprise Edition
Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

For more information , please do visit source site:
http://help.godaddy.co m/topic/290/article/1428

Answered by satyaiitk at 12:48 AM on June 03, 2008

The Standard Edition of SQL Server 2000 is the version intended for the masses—those running small- to medium-sized systems that don't require the performance, scalability, and availability provided by Enterprise Edition. The Standard Edition runs on any of the Windows 2000 or Windows NT 4.0 Server platforms with scalability limited to up to four processors and 2GB of memory. Standard Edition includes the following features:

Analysis Services
Data Transformation Services
Full Text Search
English Query
Built-in XML support
SQL Profiler and performance analysis tools
Graphical DBA and Developer tools
Replication
Data mining tools

The Standard Edition should meet the needs of most departmental and small- to mid-sized applications. However, if you need more scalability, availability, advanced performance features, or comprehensive analysis features, you will want to implement the Enterprise Edition of SQL Server 2000.

The Enterprise Edition of SQL Server 2000 is the most comprehensive and complete edition available. It provides the most scalability and availability of all editions and is intended for systems that require high performance and availability, such as large volume Web sites, data warehouses, and high throughput online transaction processing (OLTP) systems.

SQL Server 2000 Enterprise Edition supports up to 64GB of memory and up to 32 processors when it is installed on Windows 2000 Datacenter Server. It supports up to 8GB of memory and 8 processors when it is installed on Windows 2000 Advanced Server. To provide these capabilities, SQL Server 2000 Enterprise Edition can be installed only on Server versions of Windows 2000 and Windows NT.

Additionally, SQL Server 2000 Advanced Server provides performance enhancements such as parallel query, indexed views, and enhanced read-ahead scanning.

For deploying SQL Server 2000 in a server environment, either the Standard or the Enterprise Edition of SQL Server is a logical choice.

While all editions of SQL Server 2000 allow the creation of indexed views, only the Developer and Enterprise Editions of SQL Server 2000 will automatically consider using an indexed view in query plans. To force the optimizer to consider indexed views in other SQL Server editions, the NOEXPAND hint must be included in the query. For more information on using indexed views and how they are handled by the query optimizer.

Answered by Shobhit at 8:08 PM on June 02, 2008

Server Roles
The Live Communications Server architecture consists of multiple roles, each serving a different function. Your environment must include one of the first two roles, Standard Edition or Enterprise Edition, which handle the front-end operations of Live Communications Server. These roles function as a "home server" within Live Communications Server architecture. All other roles perform in conjunction with these front-end architecture components.

Standard Edition
Live Communications Server 2005 Standard Edition provides a simple way to enable presence and IM (instant messaging) services for smaller, less complex networks. Standard Edition is completely self-contained and does not require an external installation of SQL Server to operate.

Enterprise Edition
For deployments that require higher availability or greater scalability, the concept of a "home server" is divided into two distinct parts: Live Communications Server Enterprise Edition, which manages client connections, presence, and other real-time communication features like instant messaging; and Live Communications Server 2005, Back-End Database, a back-end server, running Microsoft SQL Server 2000 SP3a (Service Pack 3a), which can be clustered. Together the Enterprise Edition Server and the Back-End Database form a pool.

Users (clients) register on an Enterprise pool. Users are directed to a specific server within the pool by a load balancer that distributes the load to these servers. The load balancer exposes a single VIP (virtual Internet Protocol) address that is used by the clients to access the pool. Each server running Live Communications Server 2005 Enterprise Edition within the pool is responsible for connection processing, security and authentication, protocol processing, and server applications. Static data, such as contact lists and ACLs (access control lists) are stored as persistent data on the Live Communications Server 2005, Back-End Database. A client can register on one server in one instance and a different server at a different point in time, or might have multiple devices where the user is logged on (endpoints)—each logged on through a different server at a single point in time.

The user data is resident in Live Communications Server 2005, Back-End Database, which is a server that runs SQL Server 2000. The database contains records that hold static data previously described and dynamic user data such as endpoints and active descriptions for a user, and runs a set of stored procedure calls that form the core of the operational software. Live Communications Servers within the pool are networked to the back-end server using a high-speed network. These Live Communications Servers also run the UR (User Replicator) service to provide a connection to Active Directory® directory service so user account information can be synchronized from Active Directory to the Live Communications Server 2005, Back-End Database.

Answered by keshto at 8:03 PM on June 02, 2008

well , I am feeling HAPPY to answer your question , I would like to suggest you to access the source site if it's available , for more information.
The Enterprise Edition is the big-iron edition of SQL Server. Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

Data on SQL Server Enterprise can be carved up to work in parallel, called scaling out. Another way to provide higher uptime using this version is log shipping, meaning that changes made on one server can automatically be transferred to another server (perhaps located elsewhere) and applied to keep them in periodic sync.

Another feature that this edition provides that's often overlooked is as a back-end to reporting data. When you structure reporting data, it often has a negative impact on performance. With SQL Server Enterprise Edition, you get indexed views, which can really help a skilled developer speed up those reports.
Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. Workgroup Edition can serve as a front-end Web server or for departmental or branch office operations. It includes the core database features of the SQL Server 2005 product line.
* Standard Edition
Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for non-critical e-commerce, data warehousing, and line-of-business solutions. Standard Edition's integrated business intelligence and high-availability features provide organizations with the essential capabilities needed to support their operations.
* Enterprise Edition
Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.



For more information , please do visit source site:
http://help.godaddy.co m/topic/290/article/1428

Ho pe it will help you out.

Answered by Uttam at 7:49 PM on June 02, 2008

The Standard Edition of SQL Server 2000 is the version intended for the masses—those running small- to medium-sized systems that don't require the performance, scalability, and availability provided by Enterprise Edition. The Standard Edition runs on any of the Windows 2000 or Windows NT 4.0 Server platforms with scalability limited to up to four processors and 2GB of memory. Standard Edition includes the following features:

Analysis Services
Data Transformation Services
Full Text Search
English Query
Built-in XML support
SQL Profiler and performance analysis tools
Graphical DBA and Developer tools
Replication
Data mining tools

The Standard Edition should meet the needs of most departmental and small- to mid-sized applications. However, if you need more scalability, availability, advanced performance features, or comprehensive analysis features, you will want to implement the Enterprise Edition of SQL Server 2000.

The Enterprise Edition of SQL Server 2000 is the most comprehensive and complete edition available. It provides the most scalability and availability of all editions and is intended for systems that require high performance and availability, such as large volume Web sites, data warehouses, and high throughput online transaction processing (OLTP) systems.

SQL Server 2000 Enterprise Edition supports up to 64GB of memory and up to 32 processors when it is installed on Windows 2000 Datacenter Server. It supports up to 8GB of memory and 8 processors when it is installed on Windows 2000 Advanced Server. To provide these capabilities, SQL Server 2000 Enterprise Edition can be installed only on Server versions of Windows 2000 and Windows NT.

Additionally, SQL Server 2000 Advanced Server provides performance enhancements such as parallel query, indexed views, and enhanced read-ahead scanning.

For deploying SQL Server 2000 in a server environment, either the Standard or the Enterprise Edition of SQL Server is a logical choice.

While all editions of SQL Server 2000 allow the creation of indexed views, only the Developer and Enterprise Editions of SQL Server 2000 will automatically consider using an indexed view in query plans. To force the optimizer to consider indexed views in other SQL Server editions, the NOEXPAND hint must be included in the query. For more information on using indexed views and how they are handled by the query optimizer.

Answered by Nagendra at 6:28 PM on June 02, 2008

The Enterprise Edition is the big-iron edition of SQL Server. Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

Data on SQL Server Enterprise can be carved up to work in parallel, called scaling out. Another way to provide higher uptime using this version is log shipping, meaning that changes made on one server can automatically be transferred to another server (perhaps located elsewhere) and applied to keep them in periodic sync.

Another feature that this edition provides that's often overlooked is as a back-end to reporting data. When you structure reporting data, it often has a negative impact on performance. With SQL Server Enterprise Edition, you get indexed views, which can really help a skilled developer speed up those reports.

There's yet another benefit to this edition: The samples area is greatly enhanced in this release. For the developer, this sample code can be very useful.

There are a couple of minor issues with this edition. For one, the 64-bit version of this edition doesn't support running Data Transformation Services, although you can run that on another 32-bit system and reference a 64-bit edition. You're also limited to the Itanium 64-bit processor.

Standered edition really moves into the higher-end spectrum. It has more capabilities than its predecessor, and can even be clustered together, up to two nodes. There is no memory limits for this Edition.

In addition, the Standard Edition has a 64-bit version, which uses a flat memory space and a larger addressable CPU space. It has the following primary features:

* Relational Database Management System with development studio integration
* Clustering
* Replication
* Encryption
* Full XML support
* HTML support
* Service Broker
* Analysis Services
* Reporting Services
* Data Mining
* Common Language Runtime integration (you can write stored procedures in any .NET language)
* Integration Services (replaces the Data Transformation Services from 2000)

Answered by Ashish Yadav at 5:42 PM on June 02, 2008

well Blaladutt,
We offer three different editions of Microsoft SQL Server for installation on your Windows 2003 Standard Edition Dedicated Server. The right choice for your business depends on the size of your organization and complexity of your Web site or Web application. The editions and their descriptions are shown below:

* Workgroup Edition
Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. Workgroup Edition can serve as a front-end Web server or for departmental or branch office operations. It includes the core database features of the SQL Server 2005 product line.
* Standard Edition
Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for non-critical e-commerce, data warehousing, and line-of-business solutions. Standard Edition's integrated business intelligence and high-availability features provide organizations with the essential capabilities needed to support their operations.
* Enterprise Edition
Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

For details,please visit:
http://help.godaddy.co m/topic/290/article/1428

Answered by jaivir at 5:16 PM on June 02, 2008