Microsoft SQL Servers

Bargain Servers and Special Offers from AUD$119 per month with 100 GB bandwidth.


Microsoft SQL Server

Home | Contact | About Us | Support

SQL Server 2000 Product Overview


Business today demands a different kind of data management solution. Performance, scalability, and reliability are essential, but businesses now expect more from their key IT investments.

SQL Server 2000 exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server 2000 provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.

With the lowest implementation and maintenance costs in the industry, SQL Server 2000 delivers rapid return on your data management investment. SQL Server 2000 supports the rapid development of enterprise-class business applications that can give your company a critical competitive advantage.

Benchmarked for scalability, speed, and performance, SQL Server 2000 is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.

Easy-to-Use Business Intelligence (BI) Tools


Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server 2000 enables you to provide all of your employees with critical, timely business information tailored to their specific information needs. Every copy of SQL Server 2000 ships with a suite of BI services.

Self-Tuning and Management Capabilities


Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.

Data Management Applications and Services


Unlike its competitors, SQL Server 2000 provides a powerful and comprehensive data management platform. Every software license includes extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services. The result is the best overall business value available.

Evaluating Your Business Needs


SQL Server 2000 is available in several editions:
SQL Server 2000 Enterprise Edition (64-bit)
SQL Server 2000 Enterprise Edition
SQL Server 2000 Standard Edition
SQL Server 2000 Developer Edition
SQL Server 2000 Personal Edition
SQL Server 2000 Desktop Engine (MSDE)
SQL Server 2000 Windows CE Edition (SQL Server CE)

All products are available in Simplified Chinese, Traditional Chinese, English, French, German, Italian, Japanese, Korean, and Spanish.

To determine which edition will best suit your business needs:
1. Visit the Features by Edition page to compare features in each edition of SQL Server.
2. When you're ready to make your selection, visit the Choosing an Edition of SQL Server 2000 page.

Product Matrix


  Enterprise (64-bit) Edition Enterprise Edition Standard Edition Workgroup Edition
Overview Enterprise Edition (64-bit) provide the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications. Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.

There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:
Scalability
Availability/uptime
Performance
Advanced analysis
Standard edition is an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition.

Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:
Data Transformation Services (DTS)
Replication (snapshot, transactional, and merge)
Full-Text Search
English Query
Stored procedure development and debugging tools
SQL Profiling and performance analysis tools
Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all of the core database features needed for data management in an easy-to-use, affordable and simple to manage package. Workgroup Edition is ideal for the small organization for non-mission-critical, e-commerce, and line-of-business solutions.

All of the management features that make SQL Server easy to support and simple to manage are included in Workgroup Edition.

Workgroup Edition includes key features that allow you to easily manage and organize your data:
Enterprise Manager
Full-Text Search
Import/Export
Replication (snapshot, transactional, and merge)
Stored procedure development and debugging tools
Operating Systems Windows Server 2003 Enterprise Edition
Windows Server 2003 Datacenter Edition
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server

Windows NT Server 4.0
Windows NTServer 4.0 Enterprise Edition
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server

Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server

Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
Windows XP
Scalability Up to 64 Processors
Up to 512 GB of Memory
Maximum Database Size 1,048,516 terabytes
Up to 32 Processors
Up to 64 GB of Memory
Maximum Database Size 1,048,516 terabytes
Up to 4 Processors
Up to 2 GB of Memory
Maximum Database Size 1,048,516 terabytes
Up to 2 Processors
Up to 2 GB of Memory
Maximum Database Size 1,048,516 terabytes

* Requires SQL Server 2000 Service Pack 3 or later to be applied.

  Developer Edition Personal Edition Desktop Engine (MSDE) Windows CE Edition
Overview Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.

It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.
Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer. This edition is functionally equivalent to Standard Edition, with the following exceptions:
It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently.
It cannot act as a transactional replication publisher (subscriber only).
SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable version of SQL Server. Non-Microsoft software developers can include it in applications they build that use SQL Server to store data.
MSDE is an ideal solution for:
Client applications that require an embedded database.
Basic websites that serve up to 25 concurrent users.
New developers who are learning how to build data-driven applications.

This edition is functionally equivalent to Standard Edition with the following exceptions:
Does not include graphical management tools (Enterprise Manager).
Has a workload governor that limits the number of concurrent transactions.
Does not include any analysis capabilities (such as OLAP, DTS, data mining, and data warehousing features).
Has different scalability limits.
Windows CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE is a full-fledged member of the SQL Server 2000 family, with tools, application programming interfaces (APIs), and SQL grammar that developers and database administrators with existing SQL Server skills will recognize. SQL Server CE is the only edition of SQL Server 2000 that provides relational database management capabilities on Windows CE-based devices.

The SQL Server CE engine provides an essential set of relational database features, including:
Client applications that require an embedded database.
Basic websites that serve up to 25 concurrent users.
New developers who are learning how to build data-driven applications.

This edition is functionally equivalent to Standard Edition with the following exceptions:
an optimizing query processor
support for transactions
support for assorted data types
a compact footprint that preserves system resources
Remote data access and merge replication over Hypertext Transfer Protocol (HTTP)
Operating Systems Windows Server 2003 Standard Edition
Windows Server 2003 Enterprise Edition*
Windows Server 2003 Datacenter Edition*
Windows XP Professional
Windows 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server

Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows XP Professional
Windows 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows XP Professional
Windows XP Home
Windows 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
Windows CE version 2.11 or later
Handheld PC Pro (H/PC Pro)
Palm-size PC (P/PC)
Pocket PC
Scalability Up to 32 Processors
Up to 64 GB of Memory
Maximum Database Size 1,048,516 terabytes
Up to 2 Processors
Up to 2 GB of Memory
Maximum Database Size 1,048,516 terabytes
Up to 2 Processors
Up to 2 GB of Memory
Maximum Database Size 2 GB
1 Processor
Maximum Database Size 2 GB

* Requires SQL Server 2000 Service Pack 3 or later to be applied.

Features at a Glance


Technology Capabilities

Data Warehousing

 
Analysis (OLAP) Services Perform rapid, sophisticated analysis on large and complex data sets using multi-dimensional storage.
Closed-Loop Analysis Take analysis one step further with OLAP actions, allowing results to drive next steps in the business process.
Data Mining Discover patterns and trends with data mining, and make predictions about future trends in your business.
Data Transformation Services Automate routines that extract, transform, and load data from heterogeneous sources.
Data Warehousing Alliance Choose among broad offerings from non-Microsoft analysis tools vendors that extend Analysis Services functionality.
English Query Enable your users to pose questions in English instead of using multi dimensional expressions (MDX).
Indexed Views Gain performance from your existing hardware by storing query results and reducing response times.
Meta Data Services Increase developer productivity and reduce administrative overhead by sharing meta data among different tools and environments, using standard information models.
Office 2000 Integration Use Pivot Table Services in Microsoft Excel to enhance your data analysis.
OLAP Flexibility Use multiple dimension types for flexible business analysis.
Web-Enabled Analysis Analyze data from remote OLAP cubes that are Web accessible.

Enterprise Data Management

 
Clickstream Analysis Gain a deep understanding of online customer behavior, so that you can make better business decisions.
Distributed Partitioned Views Partition your workload among multiple servers for additional scalability.
Full Text Search Use and manage both your structured and unstructured data, including searching through Microsoft Office documents.
High Availability Maximize the availability of your business applications with log shipping, online backups, and failover clusters.
Improved Developer Productivity User-defined functions, cascading referential integrity, and the integrated Transact SQL (T-SQL) debugger allow you to reuse code to simplify the development process.
Integration with Microsoft Windows Server System, Microsoft BizTalk and Microsoft Commerce Server SQL Server 2000, in conjunction with other Microsoft Server products, provides even more power for your e-business.
Rich XML Support Simplify the integration of your back-end systems and data transfer across firewalls using XML.
Security Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.
Simplified Database Administration Automatic tuning and maintenance features enable administrators to focus on other critical tasks.
VI SAN Improve your overall system performance with built-in support for a virtual system area network (VI SAN).
Web Access to Data Connect to your SQL Server 2000 databases and OLAP cubes flexibly, by using the Web with no additional programming.
Web and Application Hosting Have your e-commerce solution hosted by an application service provider, with SQL Server 2000 support for multiple instances.

Line of Business

 
Analysis (OLAP) Services Perform rapid, sophisticated analysis on large and complex data sets using multi-dimensional storage.
Application Hosting With multi-instance support, SQL Server enables you to take full advantage of your hardware investments so that multiple applications can be run on a single server, or outsourced.
Extend Applications Support for access by devices, such as Microsoft Windows CE handheld units, provides broader access to applications and extends your user base.
High Availability Maximize the availability of your business applications with log shipping, online backups, and failover clusters.
Replication With SQL Server 2000 you can implement merge, transactional, and snapshot replication with heterogeneous systems.
Scalability Scale your applications up to 32 CPUs and 64 gigabytes (GB) RAM. SQL Server 2000 has demonstrated record-breaking performance that you can leverage.
Security Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.
Simplified Database Administration Automatic tuning and maintenance features enable administrators to focus on other critical tasks.
VI SAN Improve your overall system performance with built-in support for a virtual system area network (VI SAN).
Web Access to Data With multi-instance support, SQL Server enables you to take full advantage of your hardware investments so that multiple applications can be run on a single server, or outsourced.
XML XML support allows your data to be easily stored for use by Web applications.

Key Technologies


The key technologies included in SQL Server 2000 include:
Business Intelligence and Data Warehousing: Use your data to make better decisions with SQL Server 2000 Analysis Services. OLAP, data mining, and data warehousing tools are included at no extra cost
Data Transformation Services (DTS): With DTS you can automate processes to extract, transform and load data from heterogeneous sources.
MSDE: Develop applications that can scale seamlessly from portable computers to multiprocessor clusters with this embeddable, redistributable local data store.
Replication: Implement merge, transactional, and snapshot replication with heterogeneous systems.
SQL Server 2000 CE: Extend enterprise data management capabilities to mobile devices.
SQL Server 2000 Enterprise Edition (64-bit): Reach new heights in scalability with the 64-bit database built to take advantage of hardware enhancements of the 64-bit platform.
SQL Server 2000 Notification Services: Develop and deploy scalable Web applications that deliver personalized, timely information updates to a variety of mobile devices.
SQL Server 2000 Reporting Services: Get a comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Web-based reports.
XML: Build Web services to transform and integrate data across the enterprise to connect with partners and customers.

SQL Server 2005 Features Comparison

At Microsoft, we believe that software should provide you with choices that let you find the solution best tailored to your business’ needs. To that end, we have redesigned the SQL Server 2005 product family to better meet the needs of each customer segment with four new editions: Express, Workgroup, Standard, and Enterprise. As a low-cost mainstream database, SQL Server 2005 will deliver unprecedented value and functionality compared with competitive solutions. The four new editions will offer a range of features, from high availability and robust scalability to advanced business intelligence tools, designed to empower the people across your organization through a more secure, reliable, and productive data management platform. Additionally, with the reduced application downtime, robust scalability and performance, and tight security controls, SQL Server 2005 represents a dramatic step forward in supporting the most demanding enterprise systems in the world. Because SQL Server is part of Windows Server System, you will also receive the added benefits of reduced total cost of ownership and faster development time through the increased manageability and integration that result from the common engineering strategy implemented across Windows Server System products. The table below presents details about each of the different editions.

Notes: In the following table, the "Comments" column provides comments on the specified feature. Numbers next to check marks indicate footnotes that appear at the bottom of the page. SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

Scalability and Performance
Feature Express Workgroup Standard Enterprise Comments

Number of CPUs

1

2

4

No Limit

Includes support for multicore processors.

RAM

1 gigabyte (GB)

3 GB

Operating system maximum

Operating system maximum

Memory limited to maximum supported by operating system.

64-bit Support

Windows on Windows (WOW)

WOW

checked

checked

*

Database Size

4 GB

No Limit

No Limit

No Limit

*

Partitioning

*

*

*

checked

Support for large-scale databases

Parallel Index Operations

*

*

*

checked

Parallel processing of indexing operations

Indexed Views

*

*

*

checked

Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition.


High Availability
Feature Express Workgroup Standard Enterprise Comments

Database Mirroring

*

*

checked1

checked

Advanced high availability solution that includes fast failover and automatic client redirection

Failover Clustering

*

*

checked2

checked

*

Backup Log-shipping

*

checked

checked

checked

Data backup and recovery solution

Online System Changes

checked

checked

checked

checked

Includes Hot Add Memory, dedicated administrative connection, and other online operations

Online Indexing

*

*

*

checked

*

Online Restore

*

*

*

checked

*

Fast Recovery

*

*

*

checked

Database available when undo operations begin

1 Single REDO thread and the safety setting is always on.
2 Supports only two nodes.

Manageability
Feature Express Workgroup Standard Enterprise Comments

Auto Tuning

checked

checked

checked

checked

Automatically tunes database for optimal performance.

Profiler

*1

*2

checked

checked

*

SQL Server Management Studio Express

See Comments

checked

checked

checked

Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download

Management Studio

*

checked

checked

checked

Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio.

Database Tuning Advisor

*

*

checked

checked

Automatically suggests enhancements to your database architecture to improve performance.

Serviceability Enhancements

checked

checked

checked

checked

Dynamic management views and reporting enhancements.

Full-text Search

See comments

checked

checked

checked

Available for SQL Server Express in the SQL Server Express w/ Advanced Services download

SQL Agent Job Scheduling Service

*

checked

checked

checked

*

1 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
2 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.

Security
Feature Express Workgroup Standard Enterprise Comments

Advanced Auditing, Authentication, and Authorization

checked

checked

checked

checked

*

Data Encryption and Key Management

checked

checked

checked

checked

Built-in data encryption for advanced data security.

Integration with Microsoft Baseline Security Analyzer

checked

checked

checked

checked

Scans your system to check for common security vulnerabilities.

Integration with Microsoft Update

checked

checked

checked

checked

*


Programmability
Feature Express Workgroup Standard Enterprise Comments

Stored Procedures, Triggers, and Views

checked

checked

checked

checked

*

T-SQL Enhancements

checked

checked

checked

checked

Includes exception handing, recursive queries, and support for new data types.

Common Language Runtime and .NET Integration

checked

checked

checked

checked

*

User-defined Types

checked

checked

checked

checked

Extend the server with your own custom data types.

Native XML

checked

checked

checked

checked

Includes XML indexing and full-text XML search.

XQuery

checked

checked

checked

checked

*

Notification Services

*

*

checked

checked

Allows the building of advanced subscription and publication applications.

Service Broker

checked1

checked

checked

checked

*

1 Subscriber only.

Integration and Interoperability
Feature Express Workgroup Standard Enterprise Comments

Import/Export

checked

checked

checked

checked

*

Integration Services with Basic Transforms

*

*

checked

checked

Provides graphical extract, transform, and load (ETL) capabilities.

Integration Services Advanced Transforms

*

*

*

checked

Includes data mining, text mining, and data cleansing.

Merge Replication

checked1

checked2

checked

checked

*

Transactional Replication

checked3

checked4

checked

checked

*

Oracle Replication

*

*

*

checked

Transactional replication with an Oracle database as a publisher

Web Services (HTTP Endpoints)

*

*

checked

checked

Support for native Web services, Web Services Description Language (WSDL), and Web authentication

1 Subscriber only.
2 Publish to up to 25 subscribers.
3 Subscriber only.
4 Publish to up to five subscribers.

Business Intelligence
Feature Express Workgroup Standard Enterprise Comments

Report Server

See Comments

checked

checked

checked

Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download.

Report Builder

*

checked

checked

checked

End-user reporting tool

Reporting Data Sources

1

*

checked

checked

checked

*

Scale Out Report Servers

*

*

*

checked

*

Data Driven Subscriptions

*

*

*

checked

*

Infinite Clickthrough

*

*

*

checked

*

Data Warehousing

*

*

checked

checked

*

Star Query Optimization

checked

checked

checked

checked

*

SQL Analytical Functions

checked

checked

checked

checked

*

BI Development Studio

See Comments

2

checked3

checked

checked

Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.

Enterprise Management Tools

*

checked

checked

checked

Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore.

Native Support for Web Services
(Service Oriented Architectures)

checked4

checked5

checked

checked

Allows access to data from any device.

Analysis Services

*

*

checked

checked

Powerful analytics and data mining capabilities.

Unified Dimensional Model (UDM)

*

*

checked

checked

Enterprise business data model enables fast, interactive, ad hoc analysis of large data sets. Builds smarter reports that leverage centralized business logic and key performance indicators (KPIs), as well as the performance of UDM.

Business Analytics

*

*

checked

checked

Multidimensional Expression (MDX) scripts and MDX debugger, .NET stored procedures, Time Intelligence, KPI Framework.

Advanced Business Analytics

*

*

*

checked

Account intelligence, metadata translation, perspective and semi-additive measures.

Proactive Caching

*

*

*

checked

Provides automated caching for greater scalability and performance.

Advanced Data Management

*

*

*

checked

Partitioned cubes, parallel processing, server synchronization.

Full Writeback Support

*

*

*

checked

Dimension and cell writeback

Data Mining

*

*

checked

checked

Nine algorithms including decision and regression trees, clustering, logistic and linear regression, neural networks, naive bayes, association, sequence clustering, and time series. Build smarter reports that leverage centralized business logic and KPIs, as well as the performance of UDM.

Advanced Performance Tuning

*

*

*

checked

Additional options for tuning data mining models for the highest accuracy, performance, and scalability.

SQL Server Integration Services Data Flow Integration

*

*

*

checked

Perform data mining prediction and training operations directly in your operational data pipelines.

Text Mining

*

*

*

checked

Convert unstructured text data to structured data for analysis via reporting, online analytical processing (OLAP), or data mining.

1 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
2 Report Designer only.
3 Report Designer only.
4 Reporting Services only.
5 Reporting Services only.

Australian - Web Hosting - Dedicated Server - Server Australia - Hosting - Virtual - Server - Web Hosting Australia - Web - Webserver - Sitemap - Links

dedicated server dedicated server host cheap web server cheap dedicated hosting server australia web host window dedicated server hosting affordable web server dedicated server sql virtual dedicated server dedicated web hosting solution dedicated web hosting server hosting window dedicated server dedicated server web hosting cheap dedicated server dedicated linux server web hosting brisbane cheap server web hosting reseller cpanel microsoft 1and1 rackspace gigabit server webcentral rackspace ev1 dedicated server dedicated hosting dedicated server hosting cpanel linux server data center Brisbane, Queensland Home | Disclaimer | Terms of Service | AUP | Privacy Policy | Service Level Agreement
Copyright © 2000-2008 Oz Servers Pty Ltd
Web Hosting