Skip to content

Tarik Billa

  • Web Development
    • html
    • vue.js
    • laravel
    • css
    • javascript
    • jquery
    • node.js
    • php
    • asp.net
  • Programming
    • python
    • java
    • c
    • c++
    • c#
  • git
  • android

sql-optimization

How to delete large data of table in SQL without log?

November 14, 2022 by Tarik

If you are Deleting All the rows in that table the simplest option is to Truncate table, something like TRUNCATE TABLE LargeTable GO Truncate table will simply empty the table, you cannot use WHERE clause to limit the rows being deleted and no triggers will be fired. On the other hand if you are deleting … Read more

Categories sql-server Tags sql-optimization, sql-server, sql-server-2008 Leave a comment

Tarik Billa

Software Engineer
tarikbilla@gmail.com
+8801884414000
  • Reuse a hash in YAMLApril 17, 2024
  • Dockerfile: how to redirect the output of a RUN command to a variable?April 16, 2024
  • How to cd to a directory with spaces in the directory name?April 16, 2024
  • Maximum MIME type length when storing the type in a databaseApril 16, 2024
  • What is the difference between Unit, Integration, Regression and Acceptance Testing?April 16, 2024
© 2026 Tarik Billa