Administration

Article

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.

2001-08-28

1,500 reads

Discuss

Data Warehouse Version Management

by Les Smith

SQLServerCentral.com

Administration

Article

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-08-27

3,307 reads

Discuss

Design Oversight - Preliminary Review

by Brian Kelley

SQLServerCentral.com

Administration

Article

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-08-20

8,215 reads

Discuss

Microsoft SQL Server 2000 Security

by Additional Articles

Microsoft SQL Home

Administration

Article

This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.

2001-08-02

1,383 reads

SQL Server 6.5 Data Page Structure

by Alexander Chigrik

SQLServerCentral.com

Administration

Article

This article presents the technical details of the page layout for data in SQL Server 6.5

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-07-30

2,742 reads

The Basics of Sizing a SQL Server Database

by Brian Knight

SQLServerCentral.com

Administration

Article

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2008-08-01 (first published: 2001-07-25)

43,867 reads

Discuss

SQL Server 2000 Operations Guide

by Additional Articles

Microsoft MSDN

Administration

Article

Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.

2001-07-24

933 reads