Windows 2000  SP4
SQL 2000 SP4
Our SQL error log grew to over 20GB.  Process that ran for 5 seconds were
taking 10 minutes.

All,
We want to upgrade our existing SQL Server 2000 SP4 DB to SQL2005.
On one of our testservers i have first performed a in-place upgrade and the
setup has upgraded all of our databases automatically.

I have a single RAID 5 volume for my data file. I believe I'm aware of all
the right reasons to split a single data file into multiple over more than 1
disk but is there ever an optimal point where you should look to split a
single data file into many on the same NTFS volume? For ...

Just wondering what trace flag 2330 do in SQL (2000 and 2005)? benefits and
tradeoffs and any potential problems? there does not seem to be any
information.
Thanks.

I have a table which has an PRIMARY KEY Field declared as
"uniqueidentifier". The Values are generated by the standard Guid - Creation
machanism.
As you may know, this will cause may Page-Splits and Fragmentation of the

I created clustered index on 115 million records which runs 6 hours after i
created index now it is running for 16 minutes which is fine.
if i run that query statement(update statement) 1st time it will take 16
minutes and second time it will take 50 minutes

I have a fairly complicated stored procedure that creates a report, each
portion building off preceeding TSQL statements.  I created it on a db in SQL
Server 2000 and have decided to migrate the db to 2005.  However, when I run
the script portion (not executing the stored procedure, ...

Checking Excecution Plans on Stored Procedures to Enhance the performance of
systems I have inherited.
A few Procedures involve the use of Multiple Parameters within an XML record.
(ie lists of "ID" keys used to return 1 larger recordset in one query rather

We are developing a simple application that uses a state machine to register
requests and their changes on a workflow.
Every state change is logged on a trace table.
On a production system, this table can have millions of records, so I am

hi out there
On our Windows 2003 servers w. sp1 and running MS SQL Server 2000 w. sp4 we
see from time to time that we get this error "cannot allocate 64k
continous memory" or "SQL Server could not spawn process_loginread thread"

I need an appropriate select statement for my case, the case is a table with
two columns (row id ,col1) I want to retrieve a three columns
RowId, col1 ,accumulation of col1
I wrote this select statement, but the performance is going down is there an