Alexander Chigrik

Introduction Hardware and Software Requirements SQL Server Editions Installation Types Testing an installation Literature Introduction In this article I want to tell you about some general details of SQL Server 2000 installation. I also described hardware and software requirements for SQL Server 2000 and SQL Server 2000 editions. Hardware and Software Requirements Hardware requirements: Intel […]

In this article I want to tell you about Transaction Isolation Level in SQL Server 6.5 and SQL Server 7.0, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level. There are four isolation levels: READ UNCOMMITTED READ COMMITTED REPEATABLE READ SERIALIZABLE SQL Server 6.5 supports all of […]

Introduction Direct update In-place update On-page delete/insert Full delete/insert Deferred update Literature Introduction There are two update modes in SQL Server 6.5: – Direct update – Deferred update Direct update contains three methods of modification: – In-place update – On-page delete/insert – Full delete/insert Deferred update mode always uses Full delete/insert method of modification. To […]

In this article I want to tell you about some problems, which you can have when you install SQL Server 7.0, and how you can resolve these problems. If you have problems with installation, check the following: 1. Check the hardware requirements. You should have: Alpha AXP, Intel or compatible platform Pentium 166 MHz or […]

Introduction Hardware and Software Requirements SQL Server Editions Installation Types Testing an installation Literature Introduction In this article I want to tell you about some general details of SQL Server 7.0 installation. I also described hardware and software requirements for SQL Server 7.0 and SQL Server 7.0 editions. Hardware and Software Requirements Hardware requirements: Alpha […]

Introduction Trace flags Literature Introduction In this article I want to tell you, what you should know about trace flags, and how you can use some useful trace flags in SQL Server 7.0 for administering and monitoring. Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You […]

SQL Server 7.0 supports three types of join operations: Nested-Loop joins Merge joins Hash joins In this article I want to tell you about Hash joins, what kinds of Hash joins exist, and when SQL Server will choose this kind of join operation. The Hash join will be used, if there are no adequate indexes […]

SQL Server 7.0 supports three types of join operations: Nested-Loop joins Merge joins Hash joins In this article I want to tell you about Merge joins and when SQL Server will choose this kind of join operation. This is a most effective method to join the tables. The merge join will be used, if both […]

SQL Server 7.0 supports three types of join operations: Nested-Loop joins Merge joins Hash joins In this article I want to tell you about Nested-Loop joins, what kinds of Nested-Loop joins exist, and when SQL Server will choose this kind of join operation. If you join two tables, and SQL Server optimizer choose Nested-Loop join, […]

Nested-Loop join is the only one kind of a join in SQL Server 6.5 in comparison with Nested-Loop joins, Merge joins and Hash joins in SQL Server 7.0. If you join two tables, then one table will be selected as outer table and the other as the inner table. When executing a nested-loop join, SQL […]

Introduction Trace flags Literature Introduction In this article I want to tell you what you should know about trace flags, and how you can use some useful trace flags in SQL Server 6.5 for administering and monitoring. Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You […]

Introduction SQL Server 6.5 SQL Server 7.0 Literature Introduction When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors and so on. Tempdb database contains […]