SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Installing the SQL Server 2000 Service Pack

Because of the nature of SQL Server 2000 clustering, you want to ensure that it is as reliable as possible. One of the ways to help ensure that is to be sure that you have installed the latest SQL Server 2000 Service Pack on the SQL Server 2000 Cluster before you put it into production. […]

Installing SQL Server 2000 Clustering

If you have ever installed SQL Server 7.0 in a cluster, you will need to forget what you know, as installing SQL Server 2000 into a cluster is quite different, and in fact, it is much easier.The following steps should be run from the node of the cluster that you consider your primary node. This […]

Preparing for SQL Server 2000 Clustering

The purpose of this section is to show you how to install SQL Server 2000 clustering onto a Windows 2000 two-node cluster. It already assumes that the cluster server hardware has been installed and configured correctly, and it assumes that Windows 2000 Clustering Services have also been installed and configured correctly.This document provides an example […]

How to Install SQL Server 2000 Clustering

SQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server. The purpose of this article is to show you how to install SQL Server 2000 […]

The Ultimate SQL Server

If you are like most DBAs, you probably don’t get a lot of opportunity to work on really big SQL Server machines. I mean the kind that can crunch a 10 million-row table in seconds without breaking into a sweat. The kind of server that can take requests from a 1,000 clients all at the […]

Using Index Intersection to Boost SQL Server Performance

First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance.To demonstrate how Index Intersection works, I am going to use the “authors” table from the Pubs database to first explain how the current indexes on […]

Using Stored Procedures to Manage SQL Server Security

Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures, you can ensure that your data can be accessed in a much more controlled, restricted medium. Ad hoc SQL no longer […]

Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions

Disaster recovery is a topic on the minds of many DBAs. Learn some of the basics about SQL Server disaster recovery from a leading expert in the area, Greg Robidoux of Edgewood Solutions. Greg is currently the Vice Chair for the PASS DBA Special Interest Group (SIG). In addition, he recently gave two presentations at […]

Optimizing SQL Server Performance Using Files and Filegroups

There are no devices or segments in SQL Server 7.0 and SQL Server 2000, as there were in SQL Server 6.5. Now databases reside on operating-system files. There are three types of such files: primary secondary log Each database consists of at least two files: one is a primary data file (by default, with the […]

Introduction to Data Mining with SQL Server

Data Mining Defined In order to fully comprehend, much less implement enhanced Decision Support Systems in an organization, it is necessary to understand the basic precepts behind the requirements, methodologies and business drive to obtain information. Information about an organization gathered from various sources and coalesced into a format in which business decision makers and […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |