Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Apr 8, 2003

SQL Server 2000 Gains on Oracle

By DatabaseJournal.com Staff

[From Visual Studio Magazine ]

After almost three years in the growth doldrums, suddenly databases are back in vogue. Business magazine cover articles now extol the resurgence of Internet-adapted relational database management systems (RDBMSs) as the backbone of e-business dot-coms, and tout online analytical processing (OLAP) and data mining for prospecting Web traffic patterns. So far, Oracle has captured the lion's share of the e-business database market and press attention, but Microsoft's feature-laden SQL Server 2000 promises to close that gap.

SQL Server 2000's new Extensible Markup Language (XML) extensions support supply-chain management and other business-to-business (B2B) e-commerce applications. Analysis Services (formerly OLAP Services) adds data-mining capabilities to discover patterns or trends in OLAP cubes and relational data. Distributed Partitioned Views (DPVs) let you horizontally split massive databases on "federated" servers. Indexed views speed queries having joins or aggregations. Full-text search works on both conventional text fields and HTML and Microsoft Office files stored in binary large object (BLOB) columns. User-defined functions let you write Transact-SQL (T-SQL) code that returns scalar values or new table objects. Beneficiaries of SQL Server 2000's plethora of additions run the gamut from VB developers to enterprise database administrators (see Resources for a feature list).

The article continues at http://www.fawcette.com/archives/premier/mgznarch/vbpj/2000/14fal00/rj0014/rj0014.asp

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM