Which one is faster delete/truncate? Why?
Answer / pankaj dhatrak
Truncate is more faster
reason truncate direct drop the data page and not save the transactions.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the different types of replication you can set up in sql server? : Sql server database administration
How to find out the list schema name and table name for the database?
How to store and query spatial data?
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?
What is clr ddl trigger?
What are the purpose of Normalisation?
How to turn off warning messages during php execution?
how can you attach more than 20 ldf files in sql server
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How can a user-defined datatype be created?
Define right outer join in sql server joins?
Define outer join in sql server joins?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)