Which one is faster delete/truncate? Why?
- 1 Answers
- 972 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
Explain the usage of floor function in sql server.
How to check status of stored procedure in sql server?
Can you explain powershell included in sql server 2008?
Explain the truncate command? : SQL Server Architecture
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?
How to create an index on an existing table in ms sql server?
role of sql sever 2005 in database rather than any other database
What are “unrepeatable reads”?
what kind of lan types do you know? : Sql server database administration
What is checkpoint in sql server?
How to rename an existing column with sql server management studio?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
