Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is faster delete/truncate? Why?
- 1 Answers
- 1822 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 |
Why is sql server log file full?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
What is a trigger and its types?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
How to locate and take substrings with charindex() and substring() functions?
how we can store the value like that 001,003,023 etc in sql server 2005
How to convert numeric values to integers in ms sql server?
What is difference between table aliases and column aliases? Do they affect performance?
What are the different authentication modes in sql server?
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
How to change the password of a login name in ms sql server?
What is index in an assignment?
-
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)
