Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to delete massive data quickly and conditionally in SQLSERVER". In daily operation, I believe many people have doubts about how to delete massive data quickly and conditionally in SQLSERVER. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt of "how to delete massive data quickly and conditionally in SQLSERVER". Next, please follow the editor to study!

Change the 1.SQLSERVER database type from bit to notBoolean (that is, true to false Change false to true) example: update table setbit field = bit field-1 A friend asked me recently that it was very slow for him to delete millions to tens of millions of data in SQLSERVER. I helped him analyze it and put forward some suggestions that may be useful to many people. Moreover, I haven't written BLOG for a long time. Let's discuss if your hard disk space is small. And do not want to set the log of the database to the minimum (because I want other normal logs to still record), and the speed is relatively high, and it is recommended that you use turncatetable1 to clear all the data, because truncate is a DDL operation, does not generate rollback, does not write the log faster, and then, if there is self-increment, restore to 1, while delete will generate rollback, if you delete a large amount of data table speed will be very slow At the same time, it will occupy a lot of rollbacksegments and record G-level logs at the same time. Of course, if there are conditions to delete, such as wheretime

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.