Ok so if i am creating an index from a script that recommends 'Equity', 'Inequity' and 'Included' - do i put the 'included' columns it recommends into the 'included columns'...

I dont think the updates that the SP handles are critical - I will need to speak with the developers about this i think. Thanks for your help.:-)

Thanks very much for your input.

I have taken a look at that sp and notice that the isolation level is set to Serializable ! I also notcied this in the...

Thanks very much for this - I will defo check this out.

Look forward to hearing you speak at the sql in the city conf, London in June !!!

Thanks

Steve:-)

Can anybody please advise on the last few comments ? The original file has not grown when i restart the sql server instance - the second file has been...

The initial size was 8mb - i obtained that info from the database properties by right clikcing in ssms - unless there is a better way ?

I have got rid off the extra file now!!

I then run the following to resize the original file to 650 mb and add a secondary.

ALTER DATABASE TEMPDB

MODIFY file

(NAME =...

apologies for this i am having problems !

when i try to run a dbcc shrinkfile i get an error saying

"Could not locate file 'tempdev2' for database tempdb in sys.database_files....

thank you

is this correct then :

DBCC SHRINKFILE ('tempdev2' , emptyfile)

then run the

ALTER DATABASE tempdb REMOVE FILE tempdev2

Ok thanks for the info.

So just to be clear about this one.

1. I can put the secondary tempdb file on the same disc as the primary file.

2. Make the...

thanks very much for this info.:-)