5/22/2023 0 Comments Sql server insertIn this case, there was no need to disable clustered index at all. Let us try to learn a lesson from this experience. However, what really caught my attention was the concept of disabling clustered index. I have replied to my client and helped them fixed the problem. When DBA tried to enable clustered indexes again he is facing error Incorrect syntax error. Since then our application is not working. Our DBA has changed your script a bit and included all the clustered indexes. We looked at your script and found out that in your script of disabling indexes, you have only included selected non-clustered index during the bulk insert and missed to disabled all the clustered index. Earlier today, I received following email.
0 Comments
Leave a Reply. |