I was wondering if anyone could help me I need to know all the tables in the database, which are used for INSERT & UPDATE statements only? My reason is that I want to set-up fill-factors on all the dynamic tables meaning tables that inserts and updates are taken place on it. I need a script which will lists such table information for me. Then the static that will just be read only table would have 100% fill-factors your help will be much appreciated.

Regards,


CarlWalden

__________________
CarlWalden

Your database is created in such a way that you should know that customers create orders, which create order items, which create shipments, Customers have addresses and addresses can change.
What I am trying to say is that, you determine which tables have updates and deletes within your database. By knowing your line of business and current operating procedures within your company, you should be able to know which tables will have updates and which will have a lot of adds.

There is no place that I know of in SQL Server that will give you this information.

Sal