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 |
How to find the version of sql server? : sql server database administration
How to create indexed view?
What the different types of Replication and why are they used?
What is a join and their types?
2 Answers Challenger Financial,
What are the two modes of authentication in sql server?
How to define the name and server for a new dsn?
What is the maximum size of a dimension? : sql server analysis services, ssas
How many tables can be joined in SQL Server?
How to view existing indexes on an given table using sp_help?
how to control the amount of free space in your index pages? : Sql server database administration
How can you insert null values in a column while inserting the data?
What is field in algebra?
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)