RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

ALTER TABLE SWITCH statement failed because column '%.*ls' has data type ...

ALTER TABLE SWITCH statement failed. There is no identical index in ...

'%ls' statement failed because the expression identifying partition number for the ...

Latest SQL Server Clustering Articles

Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I
This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wrong

Database Mirroring in SQL Server 2005
Mirroring allows a user to create an exact copy of a database on a different server. This article outlines how to implement mirroring in SQL Server 2005.

SQL Server 2005 Clustering Best Practices
This cluster checklist to success summarizes all of the best practices you should follow if you want to install, configure, and maintain a solid SQL Server 2005 cluster.

How to Cluster SQL Server 2005
The procedure to install a SQL Server 2005 instance onto a cluster is one of the easiest parts of getting your SQL Server 2005 cluster up and running. The SQL Server 2005 setup program is used for the install and does the hard work for you. All you have to do is make a few (but critically important) decisions.

SQL Server 7.0, 2000 and 2005 Clustering Resources
If you are seriously considering implementing SQL Server 2000 or 2005 under Windows 2000 or Windows 2003; then I highly recommend that you review these resources before you begin.

How to Cluster Windows Server 2003
Before you can install SQL Server 2005 clustering, you must first install Windows Server 2003 clustering services. In this article, we take a step-by-step approach to installing and configuring Windows 2003 clustering.

An Introduction to SQL Server 2005 Clustering Basics
Clustering is a complex technology with lots of messy details. To make it easier to understand, let's take a look at the big picture of how clustering works.

Preparing the SQL Server 2005 Clustering Infrastructure
Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here's a checklist of everything that is required before you begin installing a SQL Server 2005 cluster.

Should You Upgrade Your Current SQL Server Cluster to a SQL Server 2005 Cluster?
If your organization is like many organizations, it may have some older version SQL Server clusters in production. If so, at some point you will have to make a choice about how to upgrade them to SQL Server 2005. Let's look at the available options.

How to Create Nonkey Columns in Nonclustered Indexes in SQL Server 2005
In SQL Server 2005, we now have a new feature called "nonkey column nonclustered indexes." This new feature is a variation of the standard covering index, but with some advantages. By Brad M. McGehee.

View all articles for this topic