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
Explain the commands in sql server?
What is an indexed view?
What is stored in the mssqlsystemresource database? : sql server database administration
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is temporary table in sql server? Why we use temp table?
How will you find out if there are expensive SQL statements running or not?
Why use view instead of a table?
explain different types of backups avaialabe in sql server? : Sql server database administration
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are the different normalization forms?
What is query parameter in ssrs?
How adventureworkslt tables are related?
How to convert a numeric expression from one data type to another?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.