Most books and resources, including Microsoft.com are Windows 2000 realted. There are differences between 2000 and 2003. Microsoft does have some very good tutorials or guides if you search thier...

Sql server log says nothing. There are no errors in SQL Server. There is no fail over either since there is no actual resource failover. The windows event log shows...

well I do not htink it is the DBMS. it is the MSCS. It is nio the config. I do not know how much experience you have with it but...

Bah, Sybase allow it just fine. In the references clause just add DB qualifier. MS does not allow it that hardly means it is wrong. You are thinking invoices and...

Ehh I found the answer with some digging. You run the Virtual server install from CD and attatch to the existing virtual server and go from there.

Here is one. Can...

I tried SP's vs Dynamic SQL. Here is the short version. 100 times faster with the dsql and we do over a trillion row lookups per year. If you can...

Raid Configuration has nothing to do with defragmentation of data per say. If you understand how your index can become fragmented you can see that RAID level does not negates...

Yes I figured the controller would work. I am going to RAID 10 my log and use a seperate RAID 10 on the data. Thanks.

-Eric

Man I don't get it. I posted a long reply and it never took and now it is gone. Happens every time actually. ...

I'd always say tempdb should have the same number of spindles as the database base mdf's.

Sure, that is a nice tip. It makes sense. One question, when using hardware...

Actually I have 14 disks total and 2 are for tempdb and System tables and are 15K rpm, 2 are for log segment and are 15K, and remaining 10 disks...

This my be too simple but does the box have on access or in memory virus scanner present and running? I place my bet there. Check services for other differences...

Never mind, I though I read SATA not eSATA.

Err yep your right.

CREATE FUNCTION fn_SalesByStore (@ReturnColumn varchar(30), @ColumnWhere varchar(30), @ColumnValue varchar(30))

RETURNS VARCHAR (100)

AS

begin

 DECLARE @query AS NVARCHAR (256)

 DECLARE @val as NVARCHAR (100)

 --SELECT @query = 'select ' + @Column...

The syntax I posted for

exec @query = @val OUTPUT

It is not what I ran it is just what I typed here. Still I would not rule...