Use the ‘deferred table allocation' database option to configure the database to defer page allocation for all subsequently created user tables:
sp_dboption database_name, "deferred table allocation", true
You cannot enable deferred table allocation for any system databases (such as master, sybsystemprocs, sybsystemdb) or temporary databases.
