As a first attempt how about this:

SET LANGUAGE BRITISH

CREATE TABLE Leave (

LeaveID int IDENTITY(1,1),

LeaveType varchar(50),

LeavefromDate date,

LeaveToDate date)

INSERT INTO Leave

SELECT 'Annual','12/06/2010','15/07/2010' UNION ALL

SELECT 'Medical','12/06/2010','15/07/2010' UNION ALL

SELECT 'Emergency','12/06/2010','15/07/2010'

GO

CREATE PROCEDURE AddNewLeave @NewStart...

Bump, Anyone?

Bump, Anyone?

It has been months as mentioned before the t-log growth is preventing the rebuild.

this table is only queried once per day to produce some operational stats and as long as...

This particular index is excluded from index maintenance due to the transaction log growth during the process. We use replication and log shipping on this database to provide reporting...

Company policy deems this as maintenance that has to be performed during a maintenance window.

However it looks like is definetly a fragmentation issue as now that I have re-ran as...

Gail, thanks for the help, as soon as you said "detailed", I thought bugger, I never noticied that. Must be having an off day.

As for the stats we don't...

Gail is correct, you will incur far more reads by deleting in this manner, which will have an impact on resources. Best to only insert what you need.

Do you mean what columns are used in the index and what columns are in the INCLUDE clause of the index?

Also using sp_help on the table the index is created...

Here you go.

declare @posStart int,

@BuildStr varchar(max),

...

Thanks, that makes more sense that it is you are only licenced to a certain number or from a specif source. But it won't actually stop you if you tried...

Thanks for replying, to be fair though that does not answer my questions at all. If the sql server is going to limit connections to a specific application how is...

Not a good question to ask here!

Study Study Study you would get causght out in the end anyway.

unfortunatly not the answer I was hoping for, but thank you anyway.

Sorry I don't have access to how we set it up before as it was with another company I worked for. To be fair out network enginner did most...