Differentiate between truncate vs delete in mssql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is index fragmentation in ms sql server?

0 Answers  


How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  


How can I tell if sql server is 32 or 64 bit?

0 Answers  


How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,






Explain what are partitioned views and distributed partitioned views?

0 Answers  


what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,


Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,


How to verify the port number of the sql server?

0 Answers  


What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,


Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  


Do you know how to implement service broker?

0 Answers  


Categories