Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are triggers in ms sql server?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Define Wed Edition in SQL Azure?
How to create new tables with "select ... Into" statements in ms sql server?
When columns are added to existing tables, what do they initially contain?
How to find the service pack installed? : sql server database administration
What is a collation?
What is mean by candidate key?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is a group function explain with an example?
How do you handle datasets larger than 50 gb?
When we should use and scope of @@identity?
What is autocommit mode in sql server?
How to use transact-sql statements to access the database engine?
How do I find the query plan in sql server?
