in perfmon under Memory check "available bytes" too.

i could be wrong but i get the feeling he was trying to achieve it without the use of a cursor

BOL implies this is done on a transactional basis not a time basis?

SET @DBName = ''

WHILE @DBName IS NOT NULL

...

check this info on recovery interval option

http://msdn.microsoft.com/en-us/library/ms191154.aspx

checkpoints occur for a number of reasons

what are you shrinking data files or log files

SQL server will not shrink past an active portion of the file, if that happens to be near the end of the...

or choose script to new query window then close it and save as .sql script

local temp tables should normally clear up when out of...

and consequently the overall file size.

it would be interesting to see what happens...

assuming he is seeing a public IP address, my guess is he isn't

thanks Gail, i had a look at that. Re run the script but this time play around with the fill factor...

AFAIK the only time its really valid to use a select * is inside a correlated query, dont know if anybody else can add to or confirm this

do you mean reorganise vs drop and create rather than rebuild vs drop and create

wow, never tested it Gail. How would it account for a different fill factor though?

Agree with the last point though, dont shrink!

if you are going to shrink, at least do it after the index rebuild as pages will be moved around. If you specified a fill factor of 50 for instance...