 |
Quick Contact |
|
|
|
|
|
|
|
Customers |
|
|
|
|
|
|
Microsoft SQL Server 2005 |
|
|
|
| |
Introduction |
|
|
|
|
| |
Microsoft SQL Server 2005 extends the performance, reliability, availability, programmability, and ease-of-use of SQL Server 2000. SQL Server 2005 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications. |
| |
|
| |
Features |
|
|
|
|
| |
The following topics discuss the new features in the SQL Server 2005 components.
|
| |
| Topic |
Description |
| |
Notification Services Enhancements |
|
|
| |
Notification Services is a new platform for building highly-scaled applications that send and receive notifications. Notification Services can send timely, personalized messages to thousands or millions of subscribers using a wide variety of devices. |
|
|
| |
Reporting Services Enhancements |
|
|
| |
Reporting Services is a new server-based reporting platform that supports report authoring, distribution, management, and end-user access. |
|
|
|
| |
Service Broker is a new technology for building database-intensive applications that are secure, reliable, and scalable. Service Broker provides message queues the applications use to communicate requests and responses. |
|
|
| |
Database Engine Enhancements |
|
|
| |
The Database Engine introduces new programmability enhancements such as integration with the Microsoft .NET Framework and Transact-SQL enhancements, new XML functionality, and new data types. It also includes improvements to the scalability and availability of databases. |
|
|
| |
Data Access Interfaces Enhancements |
|
|
| |
SQL Server 2005 supplies improvements in Microsoft Data Access (MDAC) and the .NET Frameworks SQL Client provider to provide greater ease-of-use, control, and productivity for developers of database applications. |
|
|
| |
Analysis Services Enhancements (SSAS) |
|
|
| |
Analysis Services introduces new management tools, an integrated development environment and integration with the .NET Framework. Many new features extend the data mining and analysis capabilities of Analysis Services. |
|
|
| |
Integration Services Enhancements |
|
|
| |
Integration Services introduces a new extensible architecture and a new designer that separates job flow from data flow and provides a rich set of control flow semantics. Integration Services also provides improvements to package management and deployment, along with many new packaged tasks and transformations. |
|
|
|
| |
Replication offers improvements in manageability, availability, programmability, mobility, scalability, and performance. |
|
|
| |
Tools and Utilities Enhancements |
|
|
| |
SQL Server 2005 introduces an integrated suite of management and development tools that improve the ease-of-use, manageability, and operations support for large scale SQL Server systems. |
|
|
|
| |
|
| |
Difference Between Oracle and SQL Server 2000 |
|
|
|
|
| |
 |
Oracle runs on many platforms, SQL on Windows only |
|
Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database |
|
Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users) |
|
SQL is #1 in Cost/Performance and overall Performance, Oracle is good in Performance wise but it is costly. |
|
Replication is much easier in SQL |
|
Failover support in SQL is much, much easier |
|
JDBC support is much better in Oracle, although Microsoft is working on it |
|
ODBC support in both |
|
SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in. |
|
SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though. |
|
SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line |
|
Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in |
|
SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase. |
| |
|
|
| |
Feature Comparison between SQL 2000 & Oracle |
|
|
|
|
| |
|
| |
| FEATURE |
PL / SQL (ORACLE) |
T – SQL (SQL Server) |
|
| |
B-Tree indexes,
Bitmap indexes,
Partitioned indexes,
Function-based indexes,
Domain indexes |
|
|
|
|
| |
Relational tables,
Object tables,
Temporary tables,
Partitioned tables,
External tables,
Index organized tables |
|
|
| |
Relational tables,
Temporary tables |
|
|
|
| |
BEFORE triggers,
AFTER triggers,
INSTEAD OF triggers,
Database Event triggers |
|
|
| |
AFTER triggers,
INSTEAD OF triggers |
|
|
|
| |
PL/SQL statements,
Java methods,
third-generation language
(3GL) routines |
|
|
|
|
|
|
|
| |
|
| |
SQL Server 2000 and Oracle Limitations |
|
|
|
|
| |
| FEATURE |
SQL Server 2k |
Oracle 9i |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
stored procedure name length |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
constant string size in SELECT |
|
|
|
| |
constant string size in WHERE |
|
|
|
|
| |
|
| |
The SQL Server 2000 advantages |
|
|
|
|
| |
|
SQL Server 2000 is cheaper to buy than Oracle 9i Database |
|
SQL Server 2000 holds the top TPC-C performance and price/performance results. |
|
SQL Server 2000 is generally accepted as easier to install, use and manage. |
|
| |
|
| |
The Oracle 9i Database advantages: |
|
|
|
|
| |
|
Oracle 9i Database supports all known platforms, not only the Windows-based platforms. |
|
PL/SQL is more powerful language than T-SQL. |
|
More fine-tuning to the configuration can be done via start-up parameters |
|
| |
|
| |
The MySQL version 4.1 advantages: |
|
|
|
|
| |
|
MySQL version 4.1 supports all known platforms, not only the Windows-based platforms. |
|
MySQL version 4.1 requires less hardware resources. |
|
You can use MySQL version 4.1 without any payment under the terms of the GNU General Public License. |
|
| |
|
| |
| FEATURE |
SQL Server 2k, 2k5 |
My SQL 4.1 |
|
| |
General Views,
Indexed Views,
Distributed Partitioned Views |
|
|
|
| |
AFTER triggers,
INSTEAD OF triggers |
|
|
|
|
|
|
| |
Scalar functions,
Inline table-valued functions,
Multistatement table-valued functions |
|
| |
C, C++ external libraries |
|
|
|
| |
Supported for only InnoDB tables |
|
|
|
|
|
|
|
|
| |
|
| |
Limitations between SQL Server 2k and MySQL |
|
|
|
|
| |
| FEATURE |
SQL Server 2000 |
MySQL v4.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
max number of columns in GROUP BY |
|
| |
Limited only by number of bytes (8060) |
|
|
| |
max number of columns in ORDER BY |
|
| |
Limited only by number of bytes (8060) |
|
|
| |
tables per SELECT statement |
|
|
|
|
|
|
|
|
|
|
|
|
| |
constant string size in SELECT |
|
|
|
|
| |
|
| |
 |
|
