Installation

SQLServerCentral Article

Clustering SQL Server 2000 from 500 Feet

  • Article

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (7)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

68,283 reads

Blogs

DATEADD Truncates the Number Parameter: #SQLNewBlogger

By

This was an interesting thing I saw in a Question of the Day submission....

Our SQL Server is Slow! What Do I Do First?

By

Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...

Using SQLFluff

By

I thought I didn’t care about linting, and lately, I haven’t written a lot...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Eliminate a function by writing out the code is now throwing an error

By stevec883

/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...

SQL Server Migration - Redirecting Old Instance Connections to New AG Listener

By Wecks

Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...

Visit the forum

Question of the Day

A Strange Choice

What is returned when I run this code in SQL Server 2022? 

CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci

See possible answers