Disable and Enable Indexes to perform large data update in SQL Server 2008
Indexes are very important they used for making Queries run faster and to reduce execution time . But they are Headache in very large table especially when updating large number of data . The query can run for ever. So it is recommended To disable and run your update and then re enable the indexes […]
More »