MICROSOFT Sql Server 2000 Std Patch Mvl Cd Sp3 - French

Redcorp# 36809132 Article# 22802069
 Search More  Database & Plug-Ins
Redcorp# 36809132 Article# 22802069
€ 24.59 Excl. VAT
FREE Shipping on orders over
€ 100 Ex VAT.
Sql MICROSOFT Sql Server 2000 Std Patch Mvl Cd Sp3 - French
For personal help or faster delivery

+32 2 558 30 00

Develop your database solutions with the new and enhanced capabilities of SQL Server 2000. Built on the extensible foundation of SQL Server 7.0, it represents the next-generation database of the Microsoft .NET Enterprise Servers. SQL Server 2000 is the complete relational database management and analysis system for building scalable e-commerce, line-of-business, and data warehousing solutions.

New Features
Internet standards support Integrate existing systems without programming through comprehensive support for W3C standards including XML, Xpath, XSL and HTTP.
XML Views View and access relational data using XML techniques by easily mapping XML elements and attributes to relational schema.
URL and HTTP access Flexibly access data from the Web via a URL. Use Structured Query Language (SQL), XML templates or XPath in URLs for querying.
SELECT . FOR XML Return XML from SQL queries and easily control the shape of the returned XML tree with three formatting options.
OpenXML Access, manipulate and update XML documents as if they were tables using T-SQL and stored procedures.
XML Updategrams - available through download after release Use XML to selectively insert, update and delete table data from anywhere, even through firewalls

XML bulk load - available through download after release Seamlessly transmit, transform and load data from any source into SQL Server 2000 relational tables.

Integrated Data Mining Analyze collected relational and OLAP data including clickstreams and purchase histories to recognize trends and make predictions. Close the loop by delivering personalized content.
HTTP access to cubes Make cubes available through firewalls for Web-based analysis applications using an HTTP listener built into SQL Server 2000 Enterprise Edition.
Multi-instance support Run reliably in hosted scenarios with separate database instances per customer or application.
Installation disk imaging Create standard or default databases for server farms easily and rapidly from any machine on the network with built-in cloning technology
Distributed Partitioned Views Achieve software scale out on the data tier by partitioning workload across servers. Add additional servers for greater scalability.
Log Shipping Automatically keep databases in synch for warm standby on multiple backup servers to share load no matter how physically far apart.
Parallel index creation Take full advantage SMP hardware to speed up index creation, easing the load on frequently updated systems.
Parallel scan Accelerate scans on multi-processor systems to improve overall database performance.
Failover cluster management Reinstall or rebuild any node in a failover cluster without impacting other nodes. Easily configure fail over for replication and Distributed Partitioned Views.
32 CPU SMP system support - Requires Windows 2000 DataCenter Server Scale-up SQL Server 2000 databases to SMP systems with as many as 32 processors.

64 GB RAM support - requires Windows 2000 Data Center Server Handle the largest data sets and transactional loads with up to 64 GB of RAM for SQL Server 2000.

VI SAN support Speed communications between servers with SQL Server 2000 support for direct communication with System Area Network (SAN) devices.
Indexed views Create indexes on views to improve performance of existing queries without recoding. Speed up analysis and reporting that rely on complex views.
ROLAP dimension storage Perform analyses on huge dimensions (10M+ members) by storing such dimensions relationally.
Distributed Partition Cubes Easily use the Partition Wizard to separate one logical cube into separate physical partitions with complete transparency for flexible data storage and improved query performance.
Online index reorganization Keep the server up and running while reorganizing indexes to improve performance.
Differential backup Run backups quickly and with low server impact by only backing up changed pages.
Server-less snapshot backup5 Backup data seamlessly with effectively no impact on the database server. Restore quickly or create warm standby servers. Requires third party virtual device interface (VDI) application and enterprise storage system supporting split mirror or copy-on-write operations.
Improved Features
Full-Text Search Enable Full-Text Search across the Web and intranets for formatted documents (e.g. Word, Excel, and HTML). Track changes automatically.

Failover clustering Install failover-ready databases directly from Setup. Use active-passive failover with standby hardware or active-active failover in hardware constrained environments. Databases can failover to any surviving node with 4-node failover.

English Query Allow all users to access data via natural language queries. Graphically author queries with wizards in the included Visual Studio environment. Generate MDX to query cubes.

Security in Analysis Services Lock down sensitive data by defining security for dimensions and cells. Restrict roles to specific combinations of cells.

Dimensions Pick the most appropriate dimension type with new parent-child, ragged, changing, write-enabled and dependent dimensions.

Integrated Analysis Services Build OLAP, data warehousing and data mining solutions to derive value from data.

Data Transformation Services (DTS) Import and export primary and foreign keys between supported database products. Program the multi-phase data pump and save DTS packages as Visual Basic code.

Security Protect data with higher default security on install. Includes support for Secure Sockets Layer (SSL) connections and Kerberos. C2-level certification underway.

Linked OLAP cubes Link OLAP cubes on different servers to supercharge analysis. Securely share or sell source cube data over the Internet.

zarallel DBCC Verify database data quickly and efficiently with multi-processor support.

  • Fully Web-Enabled...Query, analyze and manipulate data over the Web. Use Extensible Markup Language (XML) in SQL Server 2000 to exchange data between loosely coupled systems. Access data easily and securely from a browser, through firewalls, and perform fast full-text searches of formatted documents. Analyze and link online analytical processing (OLAP) cubes, even over the Web. Perform click stream analysis to learn about your Web customers.

  • Highly Scalable and Reliable...Grow without limits with enhanced scalability and reliability features. Partition your database workload to achieve scale-out of applications. Take full advantage of Symmetric Multiprocessing (SMP) hardware, and, with the Microsoft Windows 2000 Data center. Server operating system, support up to 32 CPUs and 64 GB of RAM.

  • Fastest Time-to-Market...Rapidly build, deploy, and manage e-commerce, line-of-business, and data warehousing solutions. Perform sophisticated data mining on customer and financial data. Reduce development time with the integrated T-SQL debugger, and develop your own functions that can be reused in different applications. SQL Server 2000 provides the fastest route to Web application development.

System Requirements
SQL Server 2000, all editions
Computer/Processor Intel® or compatible. Pentium 166 MHz or higher, Pentium PRO, Pentium III, or the minimum processor required for your operating system, which varies for SQL Server editions.

Note Microsoft SQL Server 2000 does not have a hardware compatibility list (HCL). If your system meets the minimum requirements listed above, SQL Server 2000 software works on the hardware certified for use with the Microsoft Windows® operating system you are using. For information about the hardware certified for use with your Windows operating system, see the HCL for your version of Windows.
  • Enterprise Edition: 64 MB minimum 64 GB
  • Standard Edition: 32 MB minimum
Hard Disk
  • SQL Server 2000, full install: 180 MB
  • SQL Server 2000, typical install: 170 MB
  • SQL Server 2000, minimum install: 65 MB (minimum)
  • SQL Server 2000, client tools only: 90 MB
  • Analysis Services: 50 MB
  • English Query: 12 MB
Operating System Note On Microsoft Windows NT® Server 4.0, Service Pack 5 (SP 5) or later must be installed as a mimimum requirement for all SQL Server 2000 editions.
  • Enterprise Edition. Microsoft Windows NT Server 4.0 (Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Advanced Server, and Windows 2000 Data Center Server).

    Note: Microsoft Windows 2000 Server is required for some SQL Server 2000 features.
  • Standard Edition. Microsoft Windows NT Server 4.0, Windows 2000 Server, Microsoft Windows NT Server Enterprise Edition, Windows 2000 Advanced Server, and Windows 2000 Data Center Server.
  • Personal Edition. Microsoft Windows 98, Windows NT Workstation 4.0, Windows 2000 Professional, Microsoft Windows NT Server 4.0, Windows 2000 Server, and all the more advanced Windows operating systems.
  • Developer Edition. Windows NT Workstation 4.0, Windows 2000 Professional, and all other Windows NT and Windows 2000 operating systems.
Miscellaneous To insall Client Tools Only Windows NT 4.0, Windows 2000 (all versions), and Windows 98.

To install Connectivity Only
Windows NT 4.0 or Windows 2000, Windows 98, and Windows 95.

Internet Requirements

Internet software Microsoft Internet Explorer 5.0 is required for all installations of Microsoft SQL Server 2000, except for the Connectivity Only option, which requires Microsoft Internet Explorer 4.01 with Service Pack 2. Internet Explorer is required for Microsoft Management Console (MMC) and HTML Help. A minimal install is sufficient, and Internet Explorer does not need to be your default browser.

Internet Information Services If you are writing XML applications, see System Requirements for the IIS Virtual Directory Management for SQL Server Utility.

Network Software Requirements Microsoft Windows NT, Windows 2000, Windows 98, and Windows 95 have built-in network software. No other network software is required, unless you are using Banyan VINES or AppleTalk ADSP.

Novell NetWare client suppor


Related products

} );