Question : Is it possible to configure SQL Server user so that he doesn’t have access to DDL statements but […]
Tag: truncate
Difference between DROP and TRUNCATE
Question : What does the TRUNCATE do differently to drop? I believe it deletes all the data in the table […]
Truncate with where clause
Question : Can I use truncate command with a where clause? I need to remove specific rows from several tables. […]
Why do I have to backup a transaction log twice for it to shrink?
Question : This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink […]
MySQL: OPTIMIZE after TRUNCATE?
Question : Using MySQL (either InnoDB or MyISAM tables–I have both), if I TRUNCATE a table and then LOAD DATA […]
truncate table in mysql 8.0 is slower than older version
Question : I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed […]
Releasing disk space by using DELETE or TRUNCATE?
Question : More than a week ago, I deleted all the rows in a postgresql table (not via truncate, instead […]
Create table using select statement Truncated incorrect datetime value:
Question : I have looked up different answers on similar question before posting it here. So i have a table […]
Truncate parent table but not children
Question : I have a table in PostgreSQL 9.4 that I partitioned so that all inserts to the parent actually […]
How to get last truncated time for each tables in SQL Server database
Question : I have a SQL Server 2012 database. Is it possible to get last truncated time for all tables […]