Hi everyone,

thx for help 🙂

ok

I resolve the problem, (i dont have any constraints ) but I had to add new one to table_tmp and then switch table

Hi,

I want to create procedure.

This procedure will be call from some another procedure.

The aplicattion which will be use all stored procedures should have not possibility to call this procedure.

it works now, tx 🙂

For example i have table with 31721 rows this table takes 250MB.

This table has clustered index and 5 non-clustered.

dm_db_index_physical_stats show me that

avg_fragmentation_in_percent = 66.6666666666667

avg_page_space_used_in_percent = 73.9189523103533