Quote:
Originally Posted by Sedrika
You should also shrink the database after doing that at least.
|
You'll better go with removing the old database files and using scripts to create a new one. Shrinking is bad use-case, since it causes a lot fragmentation.
Also, truncate table should be used instead of delete from.