databasejournal.com databasejournal.com

Comparing MSDE 1.0 to SQL Server 7.0

Introduction The comparison Hardware and Software Requirements MSDE Restrictions Pricing and Licensing Some useful tips Upgrading from MSDE to SQL server Creating and designing MSDE databases Literature Introduction Often people in newsgroups ask about some comparison of MSDE and SQL Server 7.0. In this article, I want to describe the differences between the Microsoft Data Engine and SQL Server 7.0 in terms...

databasejournal.com databasejournal.com

SQL Server Web Resources

Microsoft SQL Server site http://www.microsoft.com/sql/ SQL Server Content Index (find your way to specific pages about SQL Server by using this index) (link) Microsoft Personal Support Page for SQL Server (link) SQL Server White Papers http://support.microsoft.com/support/sql/papers.asp MSDN Developer Center for SQL Server http://msdn.microsoft.com/sqlserver/ Microsoft TechNet http://www.microsoft.com/technet/sql/ SQL Server...

databasejournal.com databasejournal.com

SQL Server 7.0 Datatypes

Introduction Binary datatypes Character datatypes Date and Time datatypes Numeric datatypes Integer datatypes Monetary datatypes Special datatypes Text and image datatypes Unicode Character datatypes User-Defined datatypes Introduction There are many new features in SQL Server 7.0, which not present in the previous version. There are: autogrow features, new storage engine, complete row level locking and so on. Some changes were...

databasejournal.com databasejournal.com

SQL Server 6.5 Datatypes

Introduction Binary datatypes Character datatypes Date and Time datatypes Numeric datatypes Integer datatypes Monetary datatypes Special datatypes Text and image datatypes User-Defined datatypes Introduction In this article, I want to tell you about built-in SQL Server 6.5 datatypes, about user-defined datatypes and what datatype is generally used in a particular situation. Binary datatypes Binary data is similar to hexadecimal...

databasejournal.com databasejournal.com

SQL Server 7.0 Tools and Utilities

Introduction SQL Server 7.0 Program Group Other SQL Server 7.0 Tools and Utilities Introduction SQL Server 7.0 provides many command-line and graphical tools and utilities that enhance the capabilities of the server and ease tuning and maintenance. Not all of these tools and utilities appear in Start menu, many of them don't have Start menu shortcuts. In this article, I want to tell you about these tools and utilities. SQL Server...

databasejournal.com databasejournal.com

SQL Server 6.5: Tools and Utilities

Introduction SQL Server 6.5 Program Group Other SQL Server 6.5 Tools and Utilities Introduction SQL Server 6.5 provides many command-line and graphical tools and utilities that enhance the capabilities of the server and ease tuning and maintenance. Not all of these tools and utilities appear in Start menu, many of them don't have Start menu shortcuts. In this article, I want to tell you about these tools and utilities. SQL Server...

databasejournal.com databasejournal.com

Access 97/2000 and SQL Server 7/2000 Compared

Introduction Access 97/2000 SQL Server 7.0/2000 Literature Introduction Often people in newsgroups ask about some comparison of Access and SQL Server databases. In this article, I want to tell you about some general characteristics of Access 97/2000 and SQL Server 7.0/2000, about their restrictions, and about the comparison of these products. Access 97/2000 Microsoft offers a full family of database tools for the desktop, the...

databasejournal.com databasejournal.com

SQL Server 7.0 and SQL Server 2000 Compared

Hardware and Software Requirements To install SQL Server 7.0, you should have the following hardware: Alpha AXP, Intel or compatible platform Pentium 166 MHz or higher (Pentium Pro, Pentium II and compatible) 32MB RAM (minimum), 64MB RAM and more (recommended) 180MB (full installation), 170MB (typical), 65MB (minimum), 90MB (management tools only) plus 50MB for OLAP Services and 12MB for the English Query SQL Server 7.0 can...

databasejournal.com databasejournal.com

SQL Server 7 Optimization Tips

Introduction In comparison with version 6.5, SQL Server 7.0 reduces the tuning and configuration required to administer and monitor your databases. There are many new useful features in SQL Server 7.0: autogrow features, new storage engine, complete row level locking and so on. So, you can work with SQL Server 7.0 databases without special knowledge about the internal database architecture quite successfully, but if you want...