Thanks Everyone for your input including the most recent post. Once I get to work Monday, I'll try your suggestions to create this existing index on the existing secondary...

Thanks looks like this will work. Thanks everyone for your input. Evena 50yr can still learn things..:cool:

thnxs guys, all is good!

This is what I have:

USE master

GO

-- returns SPID & DBCC INPUTBUFFER for a given kpid

DECLARE @sql nvarchar(1000), @spid int, @ParamDef nvarchar(1000)

SET @ParamDef = N'@spidOUT int OUTPUT'

SET @sql = N'SELECT @spidOUT...

Hi there:

Good article. I could have used this on a few occasions. Tryed your code but had some syntax issues:

USE master

GO

-- returns SPID & DBCC INPUTBUFFER for a...

Great, thnxs guys....this definetely helped me.

thnxs again

thnxs, I tried your solution below...

RESTORE HEADERLISTONLY FROM DISK = 'F:\MSSQL\BACKUP\HR83PRD_Log_20090421.bak'

Server: Msg 155, Level 15, State 1, Line 1

'HEADERLISTONLY' is not a recognized RESTORE option.

GO

Am I missing something?

thnxs for your reply. Yes the clustered index definetly has many keys used. This was setup just when our Peoplesoft system went live 4 yrs ago. It...

Great thnxs guys for your help.

Thnxs for you suggestion.  All is well.

Thnxs for you input, its did the trick.  Fill factors from what I have read, benefit with a large fill if the database is mainly read, and doesn't have to...

Great thnxs for your help!  Its worked out perfectly

Thhnxs for all your replies!  I will look for one of the books mentioned. I'm a newer DBA but find SQL quite interesting and appreciate the feedback and suggestions