|
|
| |
SQL Server Articles
General Concepts
Understanding SQL Server 2000 Locking
Created by: Alexander Chigrik
In this article, Alexander Chigrik tells you about SQL Server 2000 lock modes.
|
Using Microsoft SQL Server Constraints
Created by: Alexander Chigrik
In this article, Alexander Chigrik tells you about SQL Server constraints: what
a constraint is, when it is used and for which purposes. You can find in this article
some examples of constraint creation and SQL Server 2000 constraints enhancements.
|
Choosing SQL Server 2000 Data Types
Created by: Alexander Chigrik
In this article, Alexander Chigrik tells you about built-in and user-defined data types, how
SQL Server 2000 stores data on a data page, and shows some general tips to choose an
appropriate data type.
|
Transaction Isolation Level
Created by: Alexander Chigrik
In this article, Alexander Chigrik tells you about transaction isolation levels, what kind of
transaction isolation levels exist, and how you can set the appropriate transaction isolation level.
|
Microsoft SQL Server Nested-Loop Joins
Created by: Alexander Chigrik
In this article, Alexander Chigrik explains nested-loop joins in SQL Server 7.0/2000.
He explores what kinds of nested-loop joins exist, and when SQL Server chooses
this kind of join operation.
|
Microsoft SQL Server Merge Joins
Created by: Alexander Chigrik
This article by Alexander Chigrik explores merge joins and when SQL Server decides to use them.
|
Microsoft SQL Server Hash Joins
Created by: Alexander Chigrik
This article by Alexander Chigrik explores hash joins and when SQL Server decides to use
them. One of the instances when SQL Server uses these is if there are no adequate indexes on
the join columns.
|
Update Methods Used in MS SQL 7.0
Created by: Alexander Chigrik
In this article, Alexander Chigrik shows you the different ways that SQL Server can update your data.
|
Working with COM objects from within T-SQL
Created by: Alexander Chigrik
In this article, Alexander Chigrik shows you how to create COM objects inside your stored
procedures and call properties.
|
SQL Server 7.0: Some useful trace flags
Created by: Alexander Chigrik
In this article, Alexander Chigrik shows you some useful SQL Server 7.0 trace flags.
|
SQL Server 2000: Some useful trace flags
Created by: Alexander Chigrik
In this article, Alexander Chigrik shows you some useful SQL Server 2000 trace flags.
|
Using SQL Server Cursors
Created by: Alexander Chigrik
Alexander Chigrik presents a detailed guide to creating and using server side cursors
as well as tips for optimizing cursor performance.
|
|
|
|
