Pages

Friday, September 6, 2013

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’ | Journey to SQL Authority with Pinal Dave

Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large file updates in any table using SSIS is usually preceded by disabling the index and followed by enabling the index. I have seen many developers running the following query to disable… Continue Reading...

Source: SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’ | Journey to SQL Authority with Pinal Dave