9.2.4 Microsoft SQL ServerThis is NOT the latest copy of this book; click here for the latest version.
Originally based upon Sybase, MS SQL Server was rewritten from scratch some time ago to cope with many of the flaws of the Sybase platform. The latest version of MS SQL Server at the time of writing is SQL Server 2003, previously known only by its codename, "Yukon", and it provides all of the features listed previous, including stored procedures and triggers.
While it does cost money, SQL Server is relatively cheap compared to Oracle, usually weighing in under $5000 per CPU. However, that does not take into account the fact that SQL Server only runs on Windows, meaning that you will have to pay the Windows licensing costs on top of the SQL Server licensing costs.
SQL Server is a very fast database when you use all-Microsoft software, however, performance has been known to decline drastically if you use anything not by MS alongside SQL Server.
9.2.4.1 Advantages
-
Fast
-
Not too expensive
-
Feature complete
9.2.4.2 Disadvantages
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
