var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Optimizing table in mssql
Is there an optimize table command in mssql which will work the same way as "OPTIMIZE TABLE tablename" of mysql?
I have a php application that should work on both mysql and mssql. To do defragmentation, I am using the above command. Is there an equivalent in mssql?
I presume optimise table defragments the table and indexes? If not - please post what it means.
To defrag an index check out the following in BoL:
- DBCC DBREINDEX
- DBCC INDEXDEFRAG
- ALTER INDEX ... REORGANISE\ REBUILD
You will need to see which options are best for your environment.
ur codings are working excelent.