Some time we need to delete a large data and if we run the delete command as it's sometime this will not working properly or SQL Server will go to in recovery mode so let's see how we can delete a large data from SQL server table easily
I think if you want to go with this solution and your table size is more than 50GB, I think, this process will go 1 or 2 months, but you can try the following way: set rowscount 1; truncate table x;
and this maybe will take seconds and then shrink your database.
2 comments:
I think if you want to go with this solution and your table size is more than 50GB, I think, this process will go 1 or 2 months, but you can try the following way:
set rowscount 1;
truncate table x;
and this maybe will take seconds and then shrink your database.
yes ,you are right and by this approach you just remove the pointer to this table and data of table will be removed by shrink
Post a Comment