Thanks for all replys everyone, i am going to test switching to Bulk model and running the reindexing this week.

The steps i am thinking of taking now are:

1) Ensure full...

Dave, thanks for taking time out to reply.

When setting up your HP will you be creating seperate LUNS out of the storage pool to put the data, logs and tempdb...

Hi Dave,

I am wondering if you ever grasped an understanding of how the storage pooling worked and how you implemented in the end.

Reason i ask is the company i work...

I was trying this the same way as Koenraad Dendievel using a function i found elsewhere, seems to work a treat with this:

CREATE FUNCTION dbo.ConcatFruit()

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @Output VARCHAR(8000)

SELECT @Output =...

SQL version is Microsoft SQL Server  2000 - 8.00.760 which I believe is just SQL Service Pack 3a with no hotfixes on a Windows 2000 Server with Service Pack 4.