"Is the SAN replication configured as an incremental snapshot or a complete copy?"

Neither - SAN Replication is configured as synchronous meaning that all writes on the production SAN partition are...

"Could anybody please provide any documnetation or step by step guide to bring DR database online after SRDF split.Its a cluster enviroment."

I have done about 50 SQL Server DR tests...

The SQL Agent error log location is in the registry and for a default instance, has a key of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent\ErrorLogFile

This is near the key for the SQL Server parameters.

Enterprise Manager...

The terms FILLFACTOR and PAD_INDEX are very confusing due to the names and some default behavior. From BOL:

FILLFACTOR specifies a percentage that indicates how full the Database Engine should...

Easiest is to have a uniqueness constraint and a check constraint on the same column

create table OOAK -- (One Of A Kind)

(OOAK_id tinyint not null

, constraint OOAK_P unique...

select sum(score) as TotalScore

, sum( case when score > 200 then score else null end )

as GT200TotalScore

from ....

Just to be clear, neither of the two different major consulting firms that I have worked for were IBM.

During the periods of 1997-1999 and 2001 thru 2004, I was an employee of two different major consulting firms where, when assigned to projects, 60 to 70 hours per week...

In case you did not know about overtime and IBM, from http://www.theinquirer.net

January 24, 2006 -- Current and former employees of International Business Machine Corporation (IBM) today filed a nationwide class...

Please check for the following:

1. The DTC service is running on both servers.

2. SET XACT_ABORT ON is run.

3. If any of the servers are on a cluster, the DTC on...

Here is solution:

declare @PeriodStartDtdatetime

,@PeriodEndDtdatetime

,@MedicalServiceint

,@TherapyService int

,@OtherServiceDays int

set@PeriodStartDt= '2007-10-01'

set@PeriodEndDt= @PeriodStartDt + 180

set@MedicalService= 1

set@TherapyService = 2

set@OtherServiceDays = 180

/*

selectcount(*)as AnyServiceCnt

,SUM(CASE when MedicalWOTherapy.MIS is not null then 1 else 0 end ) as Medical_WO_Therapy_Cnt

,SUM(CASE when...

Yes, as single SQL statement can be written but I would be very concerned about resource utilization (e.g. the SQL would run like a pig).

Please be sure to read Jeff...

Please review the article "Please provide DDL and sample data" at

http://www.aspfaq.com/etiquette.asp?id=5006

As a guess:

Create table ItemPrices

(ItemName varchar(255) not null

,EffectiveDate datetime not null

,PriceAmt numeric(8,2) not null

,constraint ItemPrices_PK primary key...

"If this is the case, will I not be able to use more than 3 GB on server 1 though I have 8GB RAM as it is SQL server 2000...

Constraints, like indexes, exists within a table, so any DDL must reference the table. I also avoid using builtin metadata funtions like object_id and OBJECTPROPERTY, which do not support...