Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server clustering > november 2004 > threads for november 22 - 28, 2004

Filter by week: 1 2 3 4 5

How to run my Curser more faster?
Posted by raj at 11/28/2004 4:15:03 PM
I have a stored procedure written for number of updates, inserts to the database. This stored procedure takes too long to run. I have created few indexes around few tables, but the response time is not that defferent. THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and ...more >>


How to FTP via VPN to sites with real adresses on different IP's ?
Posted by Jason Robertson at 11/25/2004 5:39:56 PM
Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of my IIS sites has a real Internet address specified, w.x.y.z. So when the VPN comes up using a private IP, I can't connect to any of the FTP sites u...more >>

SAN drive config for SQL Cluster
Posted by Randy at 11/25/2004 12:27:02 PM
What's the best physical drive configuration for a SQL cluster on a SAN? Would creating a large (14drive/2buses) physcial RAID 1+0 array with appropriate sized LUNs be acceptable for the quorum, tempdb, ms-dtc, and sql tlog shared resources? Or would individual mirrored drives defined as L...more >>

SQL server 2000 will not install on Windows Server 2003 cluster
Posted by SqlJunkies User at 11/25/2004 10:46:02 AM
please help on this error i was installing SQL Server 2000 ENT on Windows Server 2003. Cluster. after assignin the VirtualServer Ip the Setup stoped and generated an event in the event viewer." Event ID:1000, Faulting Application_INS5576._MP, version 5.53.168.0, faulting module sqlsui.dll, ve...more >>

Active/Active Clustering - W2K - Adding More Instances
Posted by Mike NO[at]SPAM Synergy at 11/25/2004 9:59:05 AM
We currently have two W2K Enterprise servers running MSCS and each of these is running MS SQL2000 enterprise. The Cluster is Active/Active and we have a single instance of SQL running on each server. The question I have is would it be possible to add another Instance of SQL on both Boxes...more >>

Is Active / Active possible with 2 SQL machines and a SCSI array??
Posted by PeterD at 11/23/2004 10:03:01 AM
I have 2 DELL Windows 2003 Enterprise server machines with SQL 2000 Enterprise Edition and 1 PowerVault 220S SCSI Array set in Cluster mode hooked up to both of these machines. I want to know is it possible to use this configuration with SQL in a ACTIVE / ACTIVE state. By Active/Active, ...more >>

Distributed transaction with clustering server
Posted by Yuval Peleg at 11/23/2004 8:03:30 AM
I can't perform a distributed transaction between a remote server to the central server. I have 3 sql server 2000 enterprise edition. 2 of them are installed on win2K server (LOCAL1, LOCAL2) and the other (CENTRAL_SQL) is installed on clustering win2K server. None of them is in domain. ...more >>

Cluster does not restart SQL group after network failure
Posted by Dan at 11/22/2004 3:57:04 PM
All, We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an active/passive configuration using 2 nodes. During the course of testing it we had a general network failure in which the network was unavailable. The virtual SQL and Windows IP address resources went down a...more >>




DevelopmentNow Blog