MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the TRUNCATE TABLE statement in MSSQL?

How does TRUNCATE differ from DELETE in MSSQL?

Can you use the TRUNCATE TABLE statement on a table with a foreign key constraint in MSSQL?

How do you reset the identity column using the TRUNCATE TABLE statement in MSSQL?

What are the restrictions on using the TRUNCATE TABLE statement in MSSQL?

How do you truncate a table that is part of a partitioned table in MSSQL?

How does TRUNCATE TABLE affect transaction logs and performance in MSSQL?

. How do you handle truncation of tables with dependent objects like views and indexes in MSSQL?

How can you use TRUNCATE TABLE in a transaction to ensure atomicity in MSSQL?

Explain a scenario where using the TRUNCATE TABLE statement is crucial for a business application in MSSQL and describe how you would implement it.