What is the difference between sql server and ms sql 2000 database?

Answer 1

SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/

Answer 2

It is not true that SQL Server 2000 is better than Oracle 9i or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider. But SQL Server 2000 has some advantages in comparison with Oracle 9i and vice versa.

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.