Answer Posted / 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 |
Post New Answer View All Answers
Why use cursor in sql server?
What is indexing explain it with an example?
What is an execution plan? How would you view the execution plan?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain the creation and execution of a user-defined function in the sql server?
What are the lambda triggers?
What happens to a statement batch if there is a compilation error?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Which language is supported by sql server?
How to create a testing table with test data in ms sql server?
Explain about unique identifier data type in sql server?
What is data mart? : sql server analysis services, ssas
How many types of built in functions are there in sql server 2012?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can we add our custom code in ssis?
