please correct the answer

it should be Sales that is updated/inserted into

the fragmentation that is caused by pages not being filled

thank you, makes a lot more sense now

I am also looking to implement a policy that will prevent people from creating objects in schemas that don't exist, and I really...

check that SQL Server Agent is running

and if so try to maually run the job which was created

ok just tried it and NO_TRUNCATE seems to work fine so far

ok thank you everyone

oh ok

but I'm thinking if you only had to choose between 0, 1 or 5